Registered aircraft · 952

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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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.

N5JVAirbus Helicopters Inc · Grand Prairie, TXS/N 10012 N600HDU S Helicopters Inc · Marshville, NCBuilt 2001 · S/N 3496 N600RSHella Fun 1 LLC · Belle Isle, FLS/N 7399 N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876 N603CMSoutheast Helicopters LLC · Miami, FLBuilt 1991 · S/N 2491 N604SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9868 N6080RTemsco Helicopters Inc · Ketchikan, AKBuilt 1992 · S/N 2685 N608TTemsco Helicopters Inc · Ketchikan, AKBuilt 1998 · S/N 3151 N6094ETemsco Helicopters Inc · Ketchikan, AKBuilt 1994 · S/N 2750 N6094UTemsco Helicopters Inc · Ketchikan, AKBuilt 1994 · S/N 2751 N609TXCopters In Agriculture Llp · Sonora, TXBuilt 2009 · S/N 4776 N60NTCity Of Ontario · Ontario, CABuilt 2017 · S/N 8466 N60TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4488 N610JSListo Air LLC · San Antonio, TXBuilt 2024 · S/N 9583 N610SFReach Air Medical Services LLC · Mcclellan, CABuilt 2011 · S/N 7278 N611TCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1988 · S/N 2123 N612RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 8615 N613CMEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1632 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 N614SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1534 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 N617TVUS Helicopters Inc · Marshville, NCS/N 1725 N618MEMountain Air Helicopters Inc · Dover, DEBuilt 2011 · S/N 7127 N619LHYukon Helicopters Inc · Bethel, AKBuilt 1980 · S/N 1263 N61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTBuilt 2007 · S/N 4367 N61HLTiny Bubbles Aviation Inc · Pacoima, CAS/N 2298 N61RKDylans Rv Center LLC · Sewell, NJBuilt 1998 · S/N 3145 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 N624ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5656 N624FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9291 N624KSAerial Coalition Surveillance LLC · Winnie, TXBuilt 1989 · S/N 2183 N624TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5459 N625CLMansfield Heliflight Inc · Milton, VTS/N 5545 N625FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9365 N627TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5460 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

Back to AD 85-14-06 R1