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.

N351FSDiscovery Helicopters LLC · Las Vegas, NVBuilt 1997 · S/N 3038 N351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4704 N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508 N351HNDiscovery Helicopters LLC · Las Vegas, NVBuilt 1996 · S/N 2957 N351VSAlpine Air Alaska LLC · Girdwood, AKBuilt 2000 · S/N 3298 N352HDT Scott Dunn Construction Inc DBA · Phoenix, ORBuilt 2001 · S/N 3442 N352HPState Of Utah · Salt Lake City, UTBuilt 2015 · S/N 8097 N352PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3378 N352PDSuffolk County Police Department · Yaphank, NYBuilt 2009 · S/N 4741 N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664 N352SASycan Corp DBA · Paso Robles, CAS/N 3348 N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838 N353CEAviation Advantage Inc · Tabor City, NCBuilt 2008 · S/N 4575 N353EReeder Flying Service Inc · Twin Falls, IDBuilt 2012 · S/N 7498 N353FBNs Air Leasing LLC · Wilmington, DEBuilt 2005 · S/N 3926 N353FSDiscovery Helicopters LLC · Boulder City, NVBuilt 1998 · S/N 3127 N353HPState Of Utah · Salt Lake City, UTBuilt 2021 · S/N 9114 N353JRPrecision LLC · Mcminnville, ORBuilt 2014 · S/N 7975 N353JSCedar Heights Aircraft LLC · Rhinebeck, NYBuilt 2005 · S/N 3931 N353MHPathfinder Leasing LLC · Anchorage, AKBuilt 1999 · S/N 3267 N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722 N353SHSycan Corp DBA · Paso Robles, CABuilt 2002 · S/N 3524 N354AKAris Aviation Group LLC · Boulder City, NVS/N 4145 N354CFTristate Careflight LLC · Greenwood Village, COBuilt 2008 · S/N 4526 N354EReeder Flying Service Inc · Twin Falls, IDBuilt 2013 · S/N 7711 N354HDCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 2479 N354HPState Of Utah · Salt Lake City, UTBuilt 2022 · S/N 9146 N354LASale Reported · Milton, VTSale reported, canceledS/N 3285 N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690 N354PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3330 N354PDSuffolk County Police Department · Yaphank, NYBuilt 2004 · S/N 3889 N354SHSycan Corp DBA · Paso Robles, CABuilt 1998 · S/N 3131 N355AGHover-Views Unlimited Inc · Syosset, NYBuilt 1982 · S/N 5109 N355AMAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9864 N355ARCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 5213 N355CFAir Methods LLC · Greenwood Village, COS/N 4644 N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436 N355EXSolomon Mark Trustee · Wilmington, DEBuilt 1994 · S/N 2817 N355FFRichards William · Gardiner, NYBuilt 1982 · S/N 5133 N355HCAm Air Service LLC · Green Oaks, ILS/N 5184 N355HRNext Level Aviation LLC · Pflugerville, TXBuilt 1991 · S/N 5473 N355JCMavana As LLC · Miami, FLS/N 5517 N355NSNs Air Leasing LLC · Wilmington, DES/N 5682 N355RSThompson Flying Service LLC · Charleston, MOBuilt 2008 · S/N 4586 N355SFHowe Aviation LLC · Surprise, AZS/N 5054 N355THTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5111 N356KJB&R Trucking Inc · Carlsbad, NMBuilt 2020 · S/N 8833 N356PPhi Health LLC · Tempe, AZBuilt 2015 · S/N 8014 N357KVKavecol Inmobiliaria Inc · Guaynabo, PRS/N 7672 N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675

Back to AD 85-14-06 R1