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.

N445MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 1045 N448MELta Group Holdings LLC · Amarillo, TXBuilt 2012 · S/N 1048 N450MTMed-Trans Corp · Denton, TXBuilt 2010 · S/N 0950 N452MTMed-Trans Corp · Denton, TXBuilt 2011 · S/N 0974 N456MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0854 N459MTMed-Trans Corp · Denton, TXBuilt 2010 · S/N 0928 N461MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 1008 N492AEAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0278 N504LHAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0382 N511UWAir Med Services LLC · Lafayette, LABuilt 2006 · S/N 0511 N512WFMetro Aviation Inc · Shreveport, LABuilt 2010 · S/N 0946 N517MTMed-Trans Corp · Denton, TXS/N 0666 N523MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0821 N524MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1039 N524WFCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0830 N527BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0697 N530LNAir Methods LLC · Greenwood Village, COS/N 0471 N531LNAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2006 · S/N 0474 N533LCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0555 N534LNAir Methods LLC · Greenwood Village, COS/N 0453 N535DETentacle Corp · Walnut Creek, CABuilt 2013 · S/N 1100 N535LLMercy Hospital Springfield · Springfield, MOBuilt 2009 · S/N 0817 N535LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0365 N551HUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0490 N552TJAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0552 N555YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0561 N556MTMed Trans Corp · Denton, TXBuilt 2017 · S/N 1253 N558MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1073 N579AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0578 N586AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0709 N586WHMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 1096 N599LBAir Med Services LLC · Lafayette, LAS/N 1062 N599MSAir Med Services LLC · Lafayette, LAS/N 0684 N601MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1040 N602MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1063 N608WGsh Crows Nest LLC · Boston, MABuilt 2007 · S/N 0575 N615BDDeckoff Stephen H · St Thomas, VIBuilt 2015 · S/N 1193 N615LFAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2004 · S/N 0362 N635DHMetro Aviation Inc · Shreveport, LABuilt 2005 · S/N 0414 N635WVanderbilt University Medical Center · Nashville, TNBuilt 2007 · S/N 0635 N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064 N641ECMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0641 N655DVMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1057 N655JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 1054 N665MTMed-Trans Corp · Denton, TXBuilt 2006 · S/N 0466 N714GEPolar Star Corp · Kalispell, MTBuilt 1966 · S/N 0060 N719LSMed Trans Corp · Denton, TXBuilt 2007 · S/N 0626 N728ABMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0683 N732HMAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0487 N738AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0738

Back to AD 2016-11-21