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.

N121YPNine Five Alpha LLC · Huntsville, ALBuilt 2000 · S/N E-3359 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784 N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276 N1223HS&S Leasing Solutions LLC · Sandy Springs, GABuilt 1973 · S/N 421B0365 N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472 N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789 N1228Hodges Farms LLC · Grain Valley, MOBuilt 1987 · S/N 4608092 N1228ERag Experimental LLC · Klamath Falls, ORBuilt 1998 · S/N LIV190 N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577 N122AJPalo Alto Aviators Inc · Menlo Park, CABuilt 2005 · S/N 1547 N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475 N122CGHollywood Aviation Investments LLC · Hollywood, SCBuilt 2001 · S/N 0098 N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070 N122CVDonnellan William B · Chattanooga, TNBuilt 2003 · S/N 0450 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N122EEAir-Burt LLC · Rochester Hills, MIBuilt 2013 · S/N TH-2382 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122GHThompson Jason · River Heights, UTBuilt 2002 · S/N 0175 N122KMBruce Mellor Inc · Escalon, CABuilt 2001 · S/N 0036 N122LGStewart John H · Burlington, COBuilt 1988 · S/N E-2413 N122MG122mg Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1250 N122RLuv2av8 · Fort Pierce, FLBuilt 1997 · S/N L IV-169-P N122RCCurtis Alvis Jr · Bakersfield, CAS/N 21059298 N122RHPadussis Gary Theodore · Cape May, NJBuilt 1993 · S/N 93-301017 N122RWShick Kenneth W · Rosamond, CABuilt 2004 · S/N GT001 N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283 N122TFWampler Kenneth E · Pottstown, PABuilt 1957 · S/N 21022 N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794 N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203 N1230ZC & J Air Inc · Middleton, DEBuilt 1994 · S/N E-2875 N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793 N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794 N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815 N1234MDelta Mike Aviation LLC · Darien, CTBuilt 1997 · S/N 29-0127 N1234QDembowski Rodrick · Seattle, WABuilt 1969 · S/N E-165 N1234TBonanza LLC · Huntington, WVBuilt 1967 · S/N CE-141 N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221 N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043 N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944 N1235CWerner Christopher Wayne · Fayetteville, GABuilt 1988 · S/N CE-1235 N1236FPitcher Michael C · Mancelona, MIS/N 18502796 N1237Fraser Mark L · Fairfield, CABuilt 1980 · S/N 18504021 N1237MJ&C Walker Aviation LLC · Henderson, TXBuilt 1977 · S/N 21061927 N1238RLtx Consulting LLC · Austin, TXBuilt 1977 · S/N 340A-0272 N1239FValpey R Wesley Jr · Medford, MEBuilt 1975 · S/N 18502799 N123AMC W Myers Holdings LLC · Anthony, NMBuilt 1973 · S/N 340-0245 N123AVGc 43 LLC · Annandale, VAS/N E-319 N123AZN123az LLC · Las Vegas, NVS/N EA-498 N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41

Back to AD 86-13-04 R3