Skip to content

Registered aircraft · 306

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-11-21')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N317RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2008 · S/N 0752 N318RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 1203 N31RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 1087 N320PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0430 N320TVBristow LLC · Lake Charles, LABuilt 2006 · S/N 0467 N321LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0465 N321RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2016 · S/N 1215 N323PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0434 N324PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0571 N324XMBristow LLC · Lake Charles, LABuilt 2011 · S/N 0991 N325DBBristow LLC · Lake Charles, LABuilt 2011 · S/N 0985 N325PHPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2007 · S/N 0576 N326PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0435 N327PHPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 0445 N328PHPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 0450 N329PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0489 N330PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0514 N332PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0519 N335DHMary Hitchcock Memorial Hospital · Lebanon, NHBuilt 2010 · S/N 0913 N335MLMercy Hospital Springfield · Springfield, MOBuilt 2006 · S/N 0451 N337PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0456 N344PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0459 N347MTNorth Shore-Lij And Yale New Haven Health Medical · Great Neck, NYBuilt 2013 · S/N 1147 N348MHMaritime Helicopters · Homer, AKBuilt 2007 · S/N 0543 N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163 N36RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2009 · S/N 0859 N370PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0464 N376PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0523 N37RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0646 N381PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0611 N382PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0618 N383PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0622 N3842Air Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0428 N384PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0653 N385PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0670 N388PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0701 N389PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0710 N390PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0733 N391PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0748 N39RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2009 · S/N 0850 N405EHMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0739 N405TJAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0405 N406EHMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0726 N430TMBristow LLC · Lake Charles, LABuilt 2006 · S/N 0457 N433CMCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0755 N435DHMary Hitchock Memorial Hospital · Lebanon, NHBuilt 2016 · S/N 1233 N435LLMercy Hospital Springfield · Springfield, MOBuilt 2008 · S/N 0758 N436CMCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0800 N442MEMa Aviation Capital 1 LLC · Houston, TXBuilt 2011 · S/N 1042 N444YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0599

Back to AD 2016-11-21