Registered aircraft · 207

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

N378PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30629 N37HXHelicopter Express LLC · Chamblee, GAS/N 30038 N3803CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1968 · S/N 30006 N3804CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1980 · S/N 30314 N380PLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 30209 N390BTBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39140 N391BMBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39138 N391TCBell Textron Inc · Fort Worth, TXS/N 39147 N391TMBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39151 N395BHBell Textron Inc · Fort Worth, TXS/N 39146 N395BTBell Textron Inc · Fort Worth, TXBuilt 2026 · S/N 39158 N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012 N401TLTurbines Ltd · West Point, NES/N 36228 N402ESNorth Slope Borough · Barrow, AKBuilt 1988 · S/N 33177 N402TLFlorida State Guard · Tallahassee, FLBuilt 1998 · S/N 36212 N404HAHillsboro Aviation Inc · Hillsboro, ORBuilt 1979 · S/N 30295 N409KCKern County Fire Department · Bakersfield, CABuilt 2024 · S/N 39128 N40VACommonwealth Of Virgina Dept Of State Police · Richmond, VABuilt 2025 · S/N 39135 N411DEU S Department Of Energy · Las Vegas, NVBuilt 1991 · S/N 36030 N412ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 36320 N412ADGeorgia Dept Of Public Safety · Kennesaw, GABuilt 2006 · S/N 36425 N412ESAspen Helicopters Inc · Oxnard, CABuilt 2006 · S/N 36423 N412ETEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 36395 N412EXBell Textron Inc · Fort Worth, TXBuilt 2019 · S/N 39103 N412FCity Of Houston · Houston, TXBuilt 1996 · S/N 36142 N412TXBernailillo County Sheriffs Office · Albuquerque, NMBuilt 2010 · S/N 36550 N412VCCounty Of Ventura Sheriffs Office · Camarillo, CABuilt 2022 · S/N 39108 N412WPSalt River Project · Phoenix, AZBuilt 2022 · S/N 39106 N417ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 36309 N41VSVertol Systems Co Inc · Destin, FLS/N 31151 N41WLCopter Lease LLC Trustee · Albuquerque, NMS/N 30262 N4218SAgriforrestal Applications Inc · Arcadia, FLS/N 30084 N4359FPetroleum Helicopter Technology Inc · San Antonio, TXS/N 31117 N449RCCounty Of San Diego · El Cajon, CABuilt 1973 · S/N 30121 N456TARoberts Aircraft LLC · Cheyenne, WYBuilt 1975 · S/N 30175 N470QLVertol Systems Co Inc · Destin, FLBuilt 1989 · S/N 33200 N500EHHilcorp Equipment LLC · Anchorage, AKS/N 30945 N502THTemsco Helicopters Inc · Ketchikan, AKBuilt 1969 · S/N 30030 N508EHHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30908 N512PAPatriot Aviation Inc · Greenville, DEBuilt 1984 · S/N 31268 N515Savauge Air LLC · North Las Vegas, NVBuilt 1975 · S/N 30759 N530NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1972 · S/N 30544 N533NCStraight Up Leasing Inc · Medford, ORS/N 36403 N534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1973 · S/N 30142 N534NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30172 N535NCWest States Leasing Inc · Medford, ORBuilt 2025 · S/N 39134 N549RLAircraft Trustee Services Inc Trustee · Dover, DES/N 30215 N549RQHsg Helicopters LLC · Fort Worth, TXBuilt 2015 · S/N 37005 N551HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30088 N580SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 30294

Back to AD 2012-22-06