Registered aircraft · 18,498

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.

N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635 N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841 N1431EBrandt Terry R · Hood River, ORBuilt 1979 · S/N 18503840 N1436AWhitney Richard T Trustee · Steamboat Springs, COBuilt 2008 · S/N E-3856 N1437AWashington Adrian P · Palm Harbor, FLBuilt 1969 · S/N D-9013 N143ABMisch Keith · Staten Island, NYS/N 29-0400 N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550 N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357 N143HJHurlburt Ward B IV · Anchorage, AKBuilt 1976 · S/N 18503032 N143KPescitelli Paul · Atlanta, GABuilt 1964 · S/N D-7664 N143SWBb&D Airways LLC · N Redngtn Bch, FLS/N 310R1856 N143TMSchnautz Danny R · Pasadena, TXBuilt 2000 · S/N 29-0242 N1440R39a LLC · Sioux Falls, SDBuilt 1966 · S/N TE-175 N1446CFour Six Chuck LLC · Maynard, MABuilt 2003 · S/N 0480 N1447CAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2003 · S/N 0498 N144AAllen Engineering · San Bernardino, CABuilt 1974 · S/N D-9633 N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042 N144DGSiktberg Timothy J · Nashville, TNBuilt 1999 · S/N LIV-144-P N144JCJackson Construction Aviation LLC · Quitman, TXBuilt 1977 · S/N 340A0360 N144MLLewis University · Romeoville, ILBuilt 2000 · S/N LIV-149 N144PTHill Howard H Trustee · Portage, WIBuilt 1990 · S/N E-2553 N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496 N144SBPeters Aircraft Sales Flp · Wshngtn Ct Hs, OHBuilt 1979 · S/N CE-862 N144TDDahlberg Thomas K · Belvidere, ILBuilt 1999 · S/N E-3289 N144WPDresel Av LLC · Fayetteville, ARBuilt 1973 · S/N 21059900 N1450BBerry Boger Yacht Sales Inc · North Myrtle Beach, SCBuilt 1977 · S/N E-989 N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318 N1450MCrescent Solutions Group LLC · Camden, DEBuilt 1970 · S/N U20601450 N1454QDarden Tyson · Wasilla, AKS/N U20602900 N1457CHillen Air Corp · Dothan, ALBuilt 2003 · S/N 0547 N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457 N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459 N145JGGeldermann Bert E · Friday Harbor, WABuilt 2005 · S/N L2K-230 N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549 N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334 N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061 N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141 N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N1463CLatta Lutz M · San Francisco, CABuilt 2003 · S/N 1356 N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465 N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466 N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845 N14680Hendricks Aric W · Floydada, TXS/N 74-30643 N14687Dalessio Enterprises Inc · Smithville, TNS/N 74-30671 N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574 N1468MArctic Barnabas Ministries · Kenai, AKBuilt 1970 · S/N U20601468 N14690Davis Scott · Morse, TXBuilt 1973 · S/N 74-30637 N14691Weakley Robert Kayce · Pleasant View, TNS/N 74-30682 N14695Johnson Charles E · Vernon, TXBuilt 1974 · S/N 74-30688

Back to AD 86-13-04 R3