Skip to content

Registered aircraft · 1,880

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-10-51') 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-10-51') 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-10-51')
    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-10-51')
  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-10-51')
  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-10-51')
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.

N1007GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9164 N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250 N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 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 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N106GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9634 N106VUAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7996 N108LNAir Methods LLC · Greenwood Village, COS/N 3959 N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N109GRAir Evac Ems Inc · O Fallon, MOBuilt 2024 · S/N 9650 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995 N109TALima Whiskey Alpha LLC · Missoula, MTBuilt 1998 · S/N 3103 N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N110AWRegistered aircraftBuilt 2022 · S/N 21158 N110GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 21444 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602 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 N113EVFly Hangar 13 LLC · Mico, TXS/N 3764 N113GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 21403 N113JPJuliette Papa Leasing LLC · Kalispell, MTBuilt 1989 · S/N 2265 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 N113PHCherokee Helicopter Service LLC · Ford City, PABuilt 1980 · S/N 1298 N114GRReach Air Medical Services LLC · Santa Rosa, CABuilt 2025 · S/N 9818 N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747 N114NSNs Air Leasing LLC · Wilmington, DES/N 7866 N115AHSky High Leasing LLC · Montrose, COBuilt 2023 · S/N 9390 N115DRTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTBuilt 2025 · S/N 9724 N115GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 9820 N117GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 2326 N117HDUS Helicopters Inc · Marshville, NCS/N 3318 N117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0369 N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464 N118LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4214 N118MBMountain Air Helicopters Inc · Dover, DEBuilt 2002 · S/N 3535 N118NSAirbus Helicopters Inc · Grand Prairie, TXS/N 9964 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 N119TVU S Helicopters Inc · Marshville, NCBuilt 1988 · S/N 2122

Back to AD 2022-10-51