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.

N337PLMaglaughlin Ronald D · Udall, KSFirst renewal noticeBuilt 1969 · S/N 402A0039 N337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0869 N3382SNorthern Sonic Alaska Inc · Fairbanks, AKBuilt 1973 · S/N 18502288 N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183 N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337 N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188 N3389MRoberts Roger W Trustee · Wichita, KSBuilt 1989 · S/N CE-1412 N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392 N338HCapital Holdings Fund IV LLC · Boca Raton, FLBuilt 1982 · S/N 18504343 N338HPN338hp LLC · Omaha, NEBuilt 1993 · S/N CE-1724 N338MGEjdeha LLC · Boston, MABuilt 1989 · S/N CE-1325 N3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1976 · S/N 310R0821 N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197 N3398QRiebe Grover C Jr · Gwinner, NDBuilt 1969 · S/N 421A0108 N3399LMetz William · Laurel, MTS/N 185-1351 N3399QBaron Aviation Corporation · Broad Run, VABuilt 1975 · S/N 310R0304 N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107 N339DGRegistered aircraftS/N P21000434 N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036 N33ANeo Terra Aviation LLC · Setauket, NYBuilt 1988 · S/N CE-1222 N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412 N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632 N33CVMaintain Aviation LLC · Pomona, MOBuilt 1992 · S/N CE-1678 N33EJReinke Bradley H · Pascagoula, MSBuilt 1993 · S/N CE-1721 N33FCReece Trucking And Excavating Inc · Marysville, WAS/N 18501631 N33FSBvd Inc · Yates Center, KSBuilt 1974 · S/N D-9658 N33FXDougfly Inc · Malibu, CAS/N D-10105 N33GKDugger Glenn · Denton, TXBuilt 1990 · S/N CE-1468 N33GXSiman-Tov Yariv · Redmond, WABuilt 2004 · S/N 29-0333 N33HCSmith Christopher J · Longwood, FLBuilt 2004 · S/N 0815 N33HLKnudsen Russell G · East Troy, WIBuilt 1973 · S/N 340-0315 N33HNPalmer Airmotive Inc · Lockport, NYBuilt 1967 · S/N CE-159 N33HPHale William L · Loveland, COS/N CD-939 N33HTGroove LLC · Afton, VABuilt 1965 · S/N D-7885 N33JHRoelfs Vernon L · Eagle River, AKFirst renewal noticeBuilt 1977 · S/N 185-03410 N33JLJ L Flyers LLC · Orinda, CABuilt 1968 · S/N D-8764 N33JSBroughton Corp · Newtown Square, PABuilt 1976 · S/N CE664 N33KKMcguiness Construction Inc · Ramona, CABuilt 1990 · S/N E-2528 N33KSMeggers Roger D · Baker, MTBuilt 1987 · S/N CE-1142 N33LFJbo Airventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 340-0352 N33LPA&H Services LLC · Danville, GAS/N E-1787 N33MDSkyhawk 172 Partners LLC · Stateline, NVBuilt 1971 · S/N 30401 N33MHAkeyson Edward W · Durham, CTBuilt 1982 · S/N T30300076 N33MKFessele Martin · Bridgewater, NJBuilt 1990 · S/N CE1478 N33MUKteg LLC · Bridgeport, TXBuilt 1993 · S/N CE-1742 N33MY3 Wings LLC · Highland, MIBuilt 1987 · S/N CE-1160 N33PCFrisbee Dennis R · Denton, TXBuilt 1966 · S/N TE-77 N33PESunset Enterprises LLC · Jonesville, VAS/N TE-1018 N33PMKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1977 · S/N TJ-78 N33RHSteel Miles · Houston, TXBuilt 2006 · S/N L2K-258

Back to AD 86-13-04 R3