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.

N722PBJ & D Aviation LLC · Salem, WIBuilt 2003 · S/N 0722 N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833 N722RDR & R Aviation New Orleans LLC · New Orleans, LABuilt 2005 · S/N 1558 N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651 N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361 N72306Usda Aphis Ppq · Edinburg, TXBuilt 1969 · S/N U206-1360 N72309Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1362 N72311Qualitair LLC Trustee · MichelstadtBuilt 1985 · S/N CE-1062 N72313Alaskan Air Charter LLC · Anchorage, AKBuilt 1969 · S/N U206-1365 N7231RRegistered aircraftBuilt 1974 · S/N E-620 N72337Gilbert Daniel Keith · Kodiak, AKBuilt 1969 · S/N U206-1374 N7233FTomlinson Avionics Of Florida Inc · Fort Myers, FLBuilt 1983 · S/N CE-1026 N7233LBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1984 · S/N CE-1049 N72347Hone Landscape Company LLC · Carnation, WABuilt 1969 · S/N U206-1377 N7235HClover Crest II Inc · Key Largo, FLBuilt 1985 · S/N CE-1064 N7235QH2f2 LLC · Prairie Village, KSBuilt 1984 · S/N CE-1035 N72395Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1393 N7239RGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N TH-565 N723CPWidener Jeanette C · Snohomish, WABuilt 2004 · S/N 1216 N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217 N723FClear Skies LLC · Stuart, FLBuilt 1983 · S/N U20606714 N723HPBlue Heron Aircraft & Yacht Sales LLC · Indialantic, FLBuilt 2001 · S/N 0130 N723JCMckean Sherry · Wildorado, TXFirst renewal noticeBuilt 1977 · S/N E-1202 N723MBTerra Air LLC · Flippin, ARBuilt 1972 · S/N TE-856 N72412Intricate Bay Operating LLC · Saylorsburg, PABuilt 1969 · S/N U206-1396 N7243ABc Express LLC · Santa Barbara, CAS/N TJ-494 N7243ESlaughter Sean R · Post Falls, IDBuilt 1973 · S/N E421 N7243MExcalibur Funding LLC · Thayer, MOBuilt 1986 · S/N E-2326 N7244RContract Fabricators Inc · Holly Springs, MSBuilt 1975 · S/N TH-558 N72452B & R Farms · Lake Village, ARBuilt 1985 · S/N CE-1067 N7246AJames Dean Brant · Irvine, CABuilt 1985 · S/N CE-1068 N7247NMartin Christian E · Amagansett, NYBuilt 1976 · S/N U20603582 N7248RHerr Laron · Bristol, SDBuilt 1975 · S/N TH-578 N7248WDen Eric Air LLC · Clinton Township, MIBuilt 1985 · S/N E-2275 N724BBSend North · Anchorage, AKBuilt 1998 · S/N E-3151 N724BDEdelson David · New York, NYBuilt 1980 · S/N TJ-266 N724BHSchwartz Mark Trustee · Shingle Springs, CABuilt 1968 · S/N TE-599 N724CDStrong Evan Edward · San Antonio, TXBuilt 2001 · S/N 0070 N724CMParker Air LLC · Mobile, ALBuilt 2005 · S/N 1557 N724DEAero Air LLC · Hillsboro, ORBuilt 2004 · S/N 1140 N724LWBaggerly Steven C · Sulphur, OKBuilt 2000 · S/N E3327 N724MJSend North · Anchorage, AKBuilt 1990 · S/N E-2567 N725Butler Harris K III · Towanda, KSBuilt 1964 · S/N 185-0737 N72505Henderson Deborah R · Palo Pinto, TXBuilt 1986 · S/N CE-1076 N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213 N7250REsquenazi Jerry · Senoia, GABuilt 1974 · S/N CE-548 N7251RUtay Arthur W · South Windsor, CTBuilt 1974 · S/N CE-549 N7252RPeebles Sean Anthony · Conroe, TXBuilt 1974 · S/N E-625 N7254EJefferson State Aviation LLC · Aptos, CABuilt 1987 · S/N CE-1103 N7254TKing Up LLC · Brookhaven, GABuilt 1985 · S/N CE-1065

Back to AD 86-13-04 R3