Registered aircraft · 4,787

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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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:75-09-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
  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:75-09-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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.

N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965 N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156 N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023 N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85 N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159 N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207 N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173 N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161 N2063JWest Aviation Inc · Creston, IABuilt 1978 · S/N T18803353T N2066JKlein Flying Service Inc · Lawrenceville, ILBuilt 1978 · S/N T18803356T N2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74 N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206GSmith Air LLC · Cascade, IDBuilt 1979 · S/N U20605268 N206GAPrijatel Thomas J · Cordova, AKBuilt 1979 · S/N U20605288 N206GVSawtooth Flying Service · Mccall, IDBuilt 1978 · S/N U20604833 N206HHSawtooth Flying Service Inc · Mccall, IDBuilt 1980 · S/N U20605675 N206JWMarley William Jay Jr · Homer, AKBuilt 1981 · S/N U20606283 N206KDStubblefield Fancho F Jr Trustee · Amity, ORBuilt 1979 · S/N U20604981 N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431 N206SNDye Seed Ranch Inc · Spokane Valley, WABuilt 1979 · S/N U20605101 N206TZTeton Leasing LLC · Polatello, IDBuilt 1979 · S/N U20605165 N206WDCritical 32 Degrees LLC · Milton Freewater, ORBuilt 1984 · S/N U20606832 N206WPMorrison Richard Lee Trustee · Anchorage, AKBuilt 1980 · S/N U20605897 N206XKennedy Benjamin · Boulder, COBuilt 1968 · S/N P206-0479 N206XPAirborne Flyer LLC · Ashland, NHBuilt 1983 · S/N U20606701 N2070SThompson Robert V Trustee · Crawford, COBuilt 1975 · S/N 21061037 N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73 N2075JL & L Flying Inc · Glen Allan, MSBuilt 1978 · S/N T18803365T N2076SWarden Air LLC · Warden, WABuilt 1975 · S/N 21061043 N207DGRwr Air Inc · Tok, AKBuilt 1969 · S/N 207-00070 N207GAngry Dragon LLC · St Thomas, VIBuilt 1969 · S/N 20700091 N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370T N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N2083SDave Schmauderer · Woodland, CAS/N 21061049 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N20EZRegistration Pending · Bigfork, MTRegistration pendingBuilt 1969 · S/N 310P0078 N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050 N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067 N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918 N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690

Back to AD 75-09-13