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.

N447WAWallasch Aviation LLC · Alpine, WYBuilt 2023 · S/N 9447 N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497 N451FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9250 N452FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9293 N453FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2023 · S/N 9317 N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932 N456WXAirbus Helicopters Inc · Grand Prairie, TXS/N 9975 N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962 N472LALapd Air Support Division · Los Angeles, CABuilt 2018 · S/N 8472 N479CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8820 N47WHInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 3653 N487HBCounty Of Butte · Oroville, CABuilt 2020 · S/N 8886 N490HAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4539 N491LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8553 N493LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8764 N494LGManufacturers And Traders Trust Company · Bridgeport, CTBuilt 2019 · S/N 8750 N496LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8582 N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687 N4PAPylon Aviation Services LLC · Chandler, AZBuilt 2005 · S/N 3920 N500KVPortland General Electric Co · Portland, ORBuilt 2008 · S/N 4638 N502LMLouisville/Jefferson County Metro Government · Louisville, KYBuilt 2024 · S/N 9510 N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711 N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682 N509DRMaverick Air LLC · Deer Park, WABuilt 2014 · S/N 7887 N50NTCity On Ontario · Upland, CABuilt 2023 · S/N 9433 N5125N5125 LLC · North Las Vegas, NVBuilt 2017 · S/N 8381 N514FWOffice Of Aviation Services · Boise, IDBuilt 2023 · S/N 9339 N517MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8805 N518MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8814 N518MFCoastal Helicopters Inc · Juneau, AKBuilt 2012 · S/N 7436 N519FFSky High Leasing LLC · Montrose, COBuilt 2014 · S/N 7924 N520AHBering Air Inc · Nome, AKBuilt 2018 · S/N 8607 N521Airbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9942 N5230JSundance Helicopters Inc · Las Vegas, NVBuilt 1999 · S/N 3256 N523RHSkyyhigh LLC · South Salem, NYBuilt 2017 · S/N 8439 N523SEVfi Kr Spe I LLC · Salt Lake City, UTBuilt 2014 · S/N 7965 N529SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 7564 N530ECEl Dorado County Sheriffs Office · Placerville, CABuilt 2013 · S/N 7708 N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553 N533AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4620 N534PDepartment Of Homeland Security · Washington, DCBuilt 2018 · S/N 8499 N534PDFresno Police Department · Fresno, CABuilt 2025 · S/N 9698 N539SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 8784 N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178 N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315 N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206 N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367 N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123 N54MNWestern Sky Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 7583 N551AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4311

Back to AD 2018-01-12 R1