Registered aircraft · 18,497

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

N30813T L Irrigation · Hastings, NEBuilt 1987 · S/N E-2393 N30819Collins William T · Cameron, TXBuilt 1987 · S/N CE-1188 N3081TAviation Training Inc · Cameron Park, CABuilt 1994 · S/N CE-1781 N3082GSmith Dennis W · Oshkosh, WIBuilt 1987 · S/N CE-1124 N3082KTecair Inc · Ventura, CABuilt 1987 · S/N CE-1199 N3083GHolly Grove Flying Service Inc · Holly Grove, ARBuilt 1988 · S/N CE-1237 N3083HSalters Flying LLC · South Dartmouth, MABuilt 1988 · S/N E-2425 N3083JPrivate Jet Solutions LLC · Prior Lake, MNBuilt 1988 · S/N CE-1242 N3084MSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1988 · S/N EA-480 N3084NLaprelle James L · Placitas, NMBuilt 1988 · S/N CE-1246 N3084ZMather Clay · Orange Beach, ALBuilt 1988 · S/N E-2426 N3085FA To Z Endeavors LLC · Leawood, KSBuilt 1987 · S/N E-2396 N3085KBennett Ross G · Eustis, FLBuilt 1987 · S/N E-2401 N3085WFly Rudolf Corp · Wilmington, DEBuilt 1973 · S/N TE-954 N3086CBlue Baron Fl LLC · Saint Cloud, FLS/N TE-510 N3086KRicotta Tom · Yuma, AZBuilt 1988 · S/N E-2406 N3086WAltair Aircraft LLC · Gainesville, FLBuilt 1972 · S/N 18502042 N3088DAquasol Corp · Rock Hill, SCBuilt 1987 · S/N E-2398 N3089HWilliamsburg Air Service Inc · Kingstree, SCBuilt 1988 · S/N CE-1219 N3089ZSnyder Stephen F · Paradise Valley, AZBuilt 1987 · S/N E-2402 N308BCMike Kilo Foxtrot LLC · Wilmington, DEBuilt 1979 · S/N 21063618 N308CDM&R Transport LLC · Dover, DEBuilt 2004 · S/N 1026 N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804 N3090PRegistered aircraftBuilt 1987 · S/N CE-1107 N3092WPrimm Daniel D Jr · Lexington, KYBuilt 1973 · S/N D-9556 N30942Polar Bear Aviation LLC · Batesville, MSBuilt 1973 · S/N 21059979 N3096TBakamis Joel Alexander · South Lake Tahoe, CABuilt 1988 · S/N CE-1208 N3096WPickering Paul S · Granbury, TXBuilt 1994 · S/N CE-1786 N3097WYarbrough G Mark · Sandia Park, NMBuilt 1973 · S/N CE-473 N3099WSavage Curtis Mac · Johnstown, OHBuilt 1973 · S/N D-9561 N309CDTriangle Aviation LLC · Cary, NCBuilt 2004 · S/N 1104 N309DCRother Michael V · Granbury, TXBuilt 1979 · S/N D-10309 N309JFRozo Matthew · Chatsworth, CABuilt 2002 · S/N 0266 N30AWKnox Tommy J · Lampasas, TXBuilt 1974 · S/N 18502369 N30CAState Of California Department Of Transportation · Sacramento, CABuilt 1974 · S/N CE-508 N30CMBoardman Air Service LLC · Henderson, NEBuilt 1974 · S/N 18502443 N30DMNagle Derek · Ada, MIBuilt 1979 · S/N E-1536 N30EDN30ed LLC · Carpinteria, CABuilt 1969 · S/N D-9076 N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443 N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266 N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412 N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067 N30GHAvientur LLC · Chesterfield, MOBuilt 2007 · S/N E-3761 N30LFSignalwave LLC · Doral, FLBuilt 1980 · S/N EA-122 N30LGHusky Two Associates LLC · Brookline, MABuilt 2020 · S/N E-4145 N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046 N30LPDialysis Clinic Inc · Nashville, TNBuilt 1977 · S/N 310R0995 N30MKKelly Michael E · Cumberland, RIBuilt 1981 · S/N CE-989 N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620 N30MTMcnamara J Kevin · Cascade, IDBuilt 1977 · S/N U20604086

Back to AD 86-13-04 R3