Skip to content

Registered aircraft · 806

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:2022-01-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-03') 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:2022-01-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-03')
  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:2022-01-03')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-03')
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.

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N10248Aeroxs Inc · Swainsboro, GABuilt 1977 · S/N 1502 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N109DRBristow LLC · Lake Charles, LAS/N 31311 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N112AHUS Army · Redstone Arsenal, ALBuilt 2014 · S/N 9684 N112MTReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1129 N113AHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 9858 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 N116MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLBuilt 2017 · S/N 69042 N116TGLeonardo Helicopters US Corp · Philadelphia, PAS/N 41630 N117GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 2326 N117MKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 7196 N117NCTriple M Leasing LLC · Shreveport, LABuilt 1997 · S/N 7517 N117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0369 N117UPMetro Aviation Inc · Shreveport, LABuilt 1994 · S/N 7508 N118JMMjm Aviation LLC · Piscataway, NJBuilt 2010 · S/N 41251 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 N119MWBristow LLC · Lake Charles, LABuilt 2012 · S/N 41307 N122GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2340 N123SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7183 N127JLBristow LLC · Lake Charles, LABuilt 2011 · S/N 0976 N12MQArrow Aviation Company LLC · Broussard, LAS/N 31041 N131HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2020 · S/N 9861 N131LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9096 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 N135CJAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0495 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 N135HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2020 · S/N 9847 N135LCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0296 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 N135MHBay Life Services Corp · Columbia, MDBuilt 2000 · S/N 0131

Back to AD 2022-01-03