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.

N555VTArlo Air LLC · Columbus, OHBuilt 2010 · S/N 4988 N556SDHarris County Sheriffs Office · Houston, TXBuilt 2011 · S/N 7086 N556TXTexas Dept Of Public Safety · Austin, TXBuilt 2025 · S/N 9797 N559SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 8648 N562AHRegistered aircraftBuilt 2019 · S/N 8696 N568AENs Air Leasing LLC · Wilmington, DEBuilt 2013 · S/N 7647 N570AETemsco Helicopters Inc · Ketchikan, AKBuilt 2012 · S/N 7489 N574AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4613 N582RDCity Of San Antonio · San Antonio, TXBuilt 2024 · S/N 9496 N583SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 7567 N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736 N589SHCsc Delaware Trust Co Trustee · Wilmington, DES/N 7745 N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733 N594LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9923 N594MCEast Flagler Mosquito Control District · Palm Coast, FLBuilt 2023 · S/N 9405 N596LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9901 N597LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9885 N599SDPima County Sheriffs Department · Tucson, AZBuilt 2011 · S/N 7258 N5JVAirbus Helicopters Inc · Grand Prairie, TXS/N 10012 N600RSHella Fun 1 LLC · Belle Isle, FLS/N 7399 N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876 N604SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9868 N60NTCity Of Ontario · Ontario, CABuilt 2017 · S/N 8466 N610JSListo Air LLC · San Antonio, TXBuilt 2024 · S/N 9583 N610SFReach Air Medical Services LLC · Mcclellan, CABuilt 2011 · S/N 7278 N612RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 8615 N613RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8920 N613TCT A F Y Consulting · Bristow, VABuilt 2012 · S/N 7522 N614HHSky High Leasing LLC · Montrose, COBuilt 2016 · S/N 8305 N614RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8873 N614TCTafy Consulting · Bristow, VABuilt 2012 · S/N 7479 N617CDOklahoma II LLC · Sandy, UTBuilt 2012 · S/N 7540 N617GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4676 N618MEMountain Air Helicopters Inc · Dover, DEBuilt 2011 · S/N 7127 N61RXReach Air Medical Services LLC · Mcclellan, CABuilt 2016 · S/N 8262 N61WLCorpat Inc · Missoula, MTBuilt 2013 · S/N 7752 N6211Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8972 N621FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9127 N6227Austin Police Dept · Pflugerville, TXBuilt 2013 · S/N 7544 N622FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9136 N623FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9235 N623PDCoastal Helicopters LLC · La Vern, CABuilt 2014 · S/N 7894 N624FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9291 N625FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9365 N629AMAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3941 N62ARBird Dog Aircraft LLC · Billings, MTBuilt 2006 · S/N 4175 N62RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 8032 N631SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2004 · S/N 3891 N63MCMissouri Department Of Conservation · Jefferson City, MOBuilt 2020 · S/N 8786 N63RCKootenai Business Properties LLC · Post Falls, IDBuilt 2019 · S/N 8760

Back to AD 2018-01-12 R1