OpenAirDocs.org
AD 98-15-18 R1

Registered aircraft · 1,210

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:98-15-18-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:98-15-18-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.

N4712TKilcourse Jeffrey Kenneth · Tequesta, FLBuilt 1964 · S/N 55N4713TMichigan Air Service Corp · Troy, MIBuilt 1964 · S/N 56N4714TJed Homes Inc · Lisbon, CTBuilt 1964 · S/N 57N4717TStartin Tyler D · Colfax, WABuilt 1964 · S/N 60N4718TArcand David R · Forest Lake, MNBuilt 1964 · S/N 61N4727TRimediare Aircraft LLC · Tucson, AZBuilt 1964 · S/N 70N4729TNevergall Michael · Brighton, COBuilt 1964 · S/N 72N4730TEgge Danny C · Pelican Rapids, MNBuilt 1964 · S/N 73N4733TMacneil David · Clarkston, WABuilt 1964 · S/N 83N4734TSmiley Mark R · Baden, PABuilt 1964 · S/N 78N4736TLb Aero Services Inc · Poplar Grove, ILBuilt 1964 · S/N 80N4737TFly Buys Inn · Wilmington, DES/N 81N4739TJohn Ross St · Anchorage, AKS/N 1003N4740TGerdes Douglas R · Macon, GAS/N 1004N4743TWeaver Matthew B · Kasilof, AKBuilt 1964 · S/N 1008N4744TKolp Mark H · Andrews, TXBuilt 1964 · S/N 1010N4745TLee Andrew L · Anchorage, AKBuilt 1965 · S/N 1015N4747TRegistered aircraftBuilt 1965 · S/N 1013N474WH&H Restoration LLC · Wasilla, AKS/N 2027CN4762RGraham Richard · Judsonia, ARBuilt 2008 · S/N 22026CN47AEPolar Air LLC · Bozeman, MTBuilt 2007 · S/N 18100CN47ASM D Ham LLC · Conover, NCBuilt 1998 · S/N 21048CN47UTHogan Robert Wayne · Gainesville, TXBuilt 2008 · S/N 18102CN498XASpringer Larry E · Bothel, WABuilt 1975 · S/N 5049CN49MWRaviation LLC · Elk Mound, WIBuilt 1992 · S/N 4112CN501SDNordeen Christopher L · Salinas, CABuilt 1986 · S/N 8088CN502DFPresby Aire LLC · Berlin, NHS/N 10044CN50GACantrell James E Trustee · Madison, GABuilt 1974 · S/N 5003CN51127Elsner Henry · Greensboro, NCBuilt 1973 · S/N 2188CN51207Crosswind Ventures LLC · Carson City, NVBuilt 1973 · S/N 2186CN51229Rossettie Thomas P · Manchester, MIS/N 1087CN51273Stieler Paul O · Albert Lea, MNBuilt 1973 · S/N 1089CN512LRWood'S Executive Services Inc · Mineola, TXBuilt 1974 · S/N 6018CN51407Soper Steven Trustee · Rathdrum, IDBuilt 1973 · S/N 1090CN51419Registration Pending · Port Orchard, WARegistration pendingBuilt 1973 · S/N 1093CN51425Black James P · Kooskia, IDBuilt 1973 · S/N 1095CN51430Burke Warren V · Lakewood, COBuilt 1973 · S/N 1097CN51436Boardman Danvers · Talkeetna, AKBuilt 1973 · S/N 1101CN51445Lanier John L · Madison, ALBuilt 1973 · S/N 1106CN51456Saunders David E · Monticello, FLBuilt 1973 · S/N 1107CN51458North Idaho Crushing Inc · Moscow, IDBuilt 1973 · S/N 1114CN51460Sale Reported · Carriere, MSSale reported, pending cancellationS/N 1115CN51463Kelly John Thomas III · Bells, TXS/N 1117CN51464Registered aircraftBuilt 1973 · S/N 6002CN51468Long Dale E · Pimento, INBuilt 1973 · S/N 6008CN51473Miley Gregg E · Melba, IDBuilt 1974 · S/N 6011CN51563Buck Timothy L · Crestview, FLBuilt 1974 · S/N 6015CN51568Brown Jacob Nathaniel · Salt Lake City, UTBuilt 1974 · S/N 6024CN51571Vanwagnen Brian DBA · Jackson, MIBuilt 1974 · S/N 6026CN51572Registered aircraftBuilt 1974 · S/N 5005C
Back to AD 98-15-18 R1