Registered aircraft · 646

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:2018-01-12-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-01-12-R1') 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:2018-01-12-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-01-12-R1')
  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:2018-01-12-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-01-12-R1')
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 N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250 N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N108LNAir Methods LLC · Greenwood Village, COS/N 3959 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995 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 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 N120AMAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9596 N120PDCity Of Albuquerque · Albuquerque, NMBuilt 2024 · S/N 9503 N121RGLone Star Land & Cattle Co · Livingston, MTBuilt 2018 · S/N 8517 N1228HAirbus Helicopters Inc · Grand Prairie, TXS/N 9951 N122AHNorton Basin Services · Nome, AKBuilt 2023 · S/N 9509 N125APAustin Police Dept · Pflugerville, TXBuilt 2022 · S/N 9282 N125CLHillsboro Aviation Inc · Hillsboro, ORBuilt 2015 · S/N 7987 N125DAPayne David L Trustee · Saint Louis, MOBuilt 2022 · S/N 9154 N125EPEnbridge Energy Co Inc · Houston, TXBuilt 2019 · S/N 8650 N125NBCisco Aero LLC · Grass Range, MTBuilt 2022 · S/N 9318 N125NYOffice Of Vector Surveillance And Control · New York, NYBuilt 2019 · S/N 8745 N125PDCity Of Albuquerque · Albuquerque, NMBuilt 2019 · S/N 8667 N126BHBhi Holdings #2 LLC · Ontario, ORBuilt 2012 · S/N 7403 N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039 N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331 N127BHBhi Holdings #3 LLC · Ontario, ORBuilt 2013 · S/N 7675 N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180 N129NBPathfinder Leasing LLC · Anchorage, AKBuilt 2017 · S/N 8397 N12NYNew York Aircam Corp · Woodbury, NYBuilt 2018 · S/N 8594 N132BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2007 · S/N 4374 N137AHCity Of Dallas · Dallas, TXBuilt 2025 · S/N 9672 N140PJHelibro LLC · Red Bluff, CAS/N 8646 N141PJHelibro LLC · Red Bluff, CABuilt 2023 · S/N 9368 N14806Pinellas County · Clearwater, FLBuilt 2023 · S/N 9341 N149AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3370 N151AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3814 N151HHangar One Avionics Inc · Carlsbad, CABuilt 2024 · S/N 9647 N151RGRegistered aircraftBuilt 2010 · S/N 7049 N151RMBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 3234 N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829 N153AHNorton Basin Services · Nome, AKBuilt 2022 · S/N 9272 N153RMSls Aviation Capital 1 LLC · Newark, DEBuilt 2012 · S/N 7495 N154RPA S K Equipment Leasing LLC · Cumming, GABuilt 2021 · S/N 8954 N157AEBoeing Company · Mesa, AZBuilt 2011 · S/N 7171 N1603MCity Of San Antonio Texas · San Antonio, TXBuilt 2018 · S/N 8563 N162GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9926 N162TMSaberair LLC · Englewood, COBuilt 2019 · S/N 8654

Back to AD 2018-01-12 R1