OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,483

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
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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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.

N449WAEuroaviation Inc Trustee · KamatenS/N 18266773N44AGVanderpool Gary W · Alamo, TXBuilt 1966 · S/N 188-0138N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556N44CCColumbia Club Aero LLC · East Wenatchee, WABuilt 1971 · S/N 18260646N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764N44DRFiretextresponse LLC · Sumner, ILBuilt 1975 · S/N 18263596N44ECN44ec LLC · Caddo Mills, TXBuilt 1980 · S/N 21063972N44EEEchemann Thomas A · Sidney, OHBuilt 1979 · S/N 21063723N44FATemple Craig A · Fort Lauderdale, FLBuilt 1980 · S/N 20700659N44HRCardinal Aviation Services LLC · Castle Rock, COBuilt 1978 · S/N 21062685N44JFEureka E Solutions Inc · Austin, TXBuilt 1973 · S/N 18262579N44JGLiberty Industries LLC · Washington, DCBuilt 1965 · S/N 18256867N44LMDelpenn Flyers Inc · Dover, DEBuilt 1981 · S/N 18268030N44LUGresham Thomas H · Cascade, IDBuilt 1979 · S/N 18267355N44NTTucker Nicholas B · La Canada, CABuilt 1981 · S/N 21064531N44RBAmj Air LLC · Holland, MIBuilt 1973 · S/N 18261829N44TBPacific Horizon LLC · Eagle, IDS/N 18267207N44WHKelly Sean R · Bozeman, MTS/N 21061316N44XWMinnehan Land & Cattle · Joplin, MTS/N 18266990N4500BStartin Brandon Lee · Spokane, WABuilt 1955 · S/N 31399N4502BAshcraft Dustin William · Anchorage, AKBuilt 1955 · S/N 31401N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408N4509JHill Curtis E · Bancroft, IDBuilt 1981 · S/N T18803741TN450DHHewitt Rod · Federal Way, WAS/N 21057998N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032N450RETurrell James A · Flagstaff, AZBuilt 1953 · S/N 7586N4513BBishop Robert W · Celina, TXBuilt 1955 · S/N 31412N4515BWestern Parachute Sales Inc · Eagle Creek, ORBuilt 1955 · S/N 31414N4517B4517b Holding Group LLC · Moses Lake, WAS/N 31416N451BA1928 LLC · Salmon, IDBuilt 2005 · S/N 18281645N451CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282194N451NACooke J C Jr · Crystal Springs, MSBuilt 1969 · S/N 18259546N451SWAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1960 · S/N 50885N4521BWitthaus James K Jr · Anchorage, AKBuilt 1955 · S/N 31420N4527BKrogman Aerial Spraying Inc · Lake Lillian, MNBuilt 1955 · S/N 31426N4528BHayton James B · Sedro Woolley, WABuilt 1955 · S/N 31427N4528JRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1980 · S/N T18803744TN452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368N452JSOffroad Aviation LLC · Las Vegas, NVBuilt 1963 · S/N 18255172N452KKramarich Kenneth · Wintersville, OHBuilt 2024 · S/N 18283284N452RAMelvin Mark · Berkeley, CABuilt 1979 · S/N R18200634N4530BMichael Anna B · Daytona Beach, FLBuilt 1955 · S/N 31429N4533BHastie William B · Anchorage, AKBuilt 1955 · S/N 31432N4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745TN4534BHornung Chet R · Nikiski, AKBuilt 1955 · S/N 31433N4537BNewsom William A · Cheraw, SCBuilt 1955 · S/N 31436N453LPFrsp LLC · Watkins, COBuilt 1999 · S/N 18280453N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844N4542BWilliamson Charles F · Ocean Isle Beach, NCBuilt 1955 · S/N 31441
Back to AD 84-10-01 R1