Skip to content

Registered aircraft · 944

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

N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N100WGTotal Helicopters Unlimited · Stafford, VAS/N 57341 N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123 N101JJStillwater Aviation LLC · Champaign, ILBuilt 2022 · S/N 57443 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391 N102BFBell Textron Inc · Fort Worth, TXBuilt 2013 · S/N 57185 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N104AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2021 · S/N 21016 N104VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0704 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N105VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0724 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N110AWRegistered aircraftBuilt 2022 · S/N 21158 N110GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 21444 N110LAConsolidated Fire Protection · Pacoima, CABuilt 2005 · S/N 36392 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N110VUAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0605 N111TDWaskey Realty LLC · Baton Rouge, LABuilt 2014 · S/N 57250 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 N113GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 21403 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 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 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 N11PPUS Dept Of The Interior · Boise, IDBuilt 2003 · S/N 36316 N11ZPRegistered aircraftBuilt 2024 · S/N 21270 N120LACounty Of Los Angeles Fire Dept · Pacoima, CABuilt 2007 · S/N 36455 N122GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2340 N123SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7183 N124AMKeybank Na · Superior, COBuilt 2022 · S/N 57450 N125TTCorpat Inc · Missoula, MTS/N 21329 N127AHAirbus Helicopters Inc · Grand Prairie, TXS/N 21536 N127JLBristow LLC · Lake Charles, LABuilt 2011 · S/N 0976 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 N133LAConsolidated Fire Protection · Pacoima, CAS/N 39136 N134AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0324 N135AEDodson International Parts Inc · Rantoul, KSS/N 1127

Back to AD 2026-08-10