Skip to content

Registered aircraft · 351

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:2013-03-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:2013-03-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:2013-03-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:2013-03-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:2013-03-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:2013-03-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.

N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11078 N109ALEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11113 N109AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 22223 N109BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22055 N109CGEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11109 N109DDLitton Global LLC · Wilmington, DEBuilt 2000 · S/N 11069 N109MHGateway Air Center Inc · Merced, CABuilt 1998 · S/N 11026 N109SJCarmona Cristobal Pelaez · Laredo, TXS/N 11170 N109SPDouble Or Nothing LLC · Prosper, TXBuilt 2012 · S/N 22291 N109TGTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 2006 · S/N 11680 N10BLLeon Helicopter One LLC · Miami, FLBuilt 2009 · S/N 22105 N112MTReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1129 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 N117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0369 N126JJFci Aeronautics LLC · Marble Falls, TXBuilt 2009 · S/N 11741 N127JLBristow LLC · Lake Charles, LABuilt 2011 · S/N 0976 N129ARAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 11125 N131SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0373 N132HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2009 · S/N 0839 N134AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0324 N135AEDodson International Parts Inc · Rantoul, KSS/N 1127 N135BREurotec Vertical Flight Solutions LLC · Eudora, KSS/N 0218 N135BUMetro Aviation Inc · Shreveport, LABuilt 1997 · S/N 0015 N135CMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0706 N135DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0133 N135EDAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0335 N135GFMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0249 N135LLMercy Hospital Springfield · Springfield, MOBuilt 2006 · S/N 0491 N135LXMed-Trans Corp · Denton, TXBuilt 2011 · S/N 1004 N135MFZmog Management Company LLC · Folsom, CABuilt 2007 · S/N 0623 N135MLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 0940 N135NMh Hospital Manager LLC · Asheville, NCBuilt 1998 · S/N 0086 N135NKAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0480 N135TJAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0329 N135UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0776 N135VVMed Trans Corp · Denton, TXBuilt 2011 · S/N 1019 N135WJAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0287 N135WLMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1083 N136UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0841 N137AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0326 N137MHMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0179 N138HNAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0288 N138LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0352 N139TJAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0322 N143MHMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0613 N158BCMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0134 N159MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1199 N162AECharlotte-Mecklenburg Hospital Authority · Charlotte, NCBuilt 2013 · S/N 1125

Back to AD 2013-03-21