OpenAirDocs.org
AD 98-15-18 R1

Registered aircraft · 1,209

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.

N10020Stephens David Sr · Plains, MTBuilt 1995 · S/N 20044CN1002HSmith Michael S · Anchorage, AKBuilt 1997 · S/N 23038CN1002NMobley John E · Newark, ARS/N 21005CN1002SKucel R Scott · Dallas, TXBuilt 1995 · S/N 20056CN10034Whyte Henry T Jr · West Ossipee, NHBuilt 1996 · S/N 19045CN10069Silvestri Leonardo · Ellicott City, MDBuilt 1996 · S/N 20050CN1007UKallam Jerry · Palmer, AKBuilt 1998 · S/N 23047CN1008WRay Jonas · Palmer, AKS/N 23022CN100RVMaule Group Ltd · Wilmington, DES/N 20029CN1010KCooley Joshua · Kenai, AKBuilt 1971 · S/N 2068CN1012MLiv4edge Inc · Wilmington, DES/N 22012CN1013QCarrera Aviation LLC · Wilmington, DEBuilt 1996 · S/N 21006CN1014GUpchurch Kenneth A · Baxley, GABuilt 1996 · S/N 20049CN1014QLawler Thomas O · Lava Hot Springs, IDBuilt 1996 · S/N 23029CN10157Kuber Daniel S · Girdwood, AKBuilt 1973 · S/N 2171CN1019MBeaudoin Bernard P · Piseco, NYBuilt 1995 · S/N 20041CN101VRDunn Thomas A · Fairhope, ALBuilt 1995 · S/N 18023CN1021QHale Job · Napakiak, AKS/N 23024CN10240Geiger Richard E · Cut Bank, MTBuilt 1996 · S/N 19046CN1025NGood Aviation LLC · Oshkosh, WIBuilt 1996 · S/N 23026CN10284Katzenberger Thomas R III · Kingsville, MDBuilt 1996 · S/N 22011CN1029NS-50 Hanger LLC · Juneau, AKBuilt 1996 · S/N 21010CN102MDFarrington Kelly · Sisters, ORS/N 2127CN1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN10329Lissow William M · New Port Richey, FLS/N 22018CN10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022CN1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012CN1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN103GSDuce Phillip N · Kotzebue, AKBuilt 1975 · S/N 6079CN103HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17007CN103PZRaging Thermal Sky Sports LLC · Brighton, COBuilt 2005 · S/N 25102CN1040RRees Christopher · Winston Salem, NCBuilt 1996 · S/N 21008CN10421Registered aircraftBuilt 1997 · S/N 21017CN1042JJac LLC · Denham Springs, LAS/N 21024CN1042LHale Cynthia G · Upper Black Eddy, PAS/N 14087CN10438Czerwonka David E · Rumford, RIBuilt 1997 · S/N 21031CN1044FNottorf Eric W · Keller, TXBuilt 1995 · S/N 20046CN1044LFitch Mark · Anchorage, AKBuilt 1996 · S/N 25009CN1044NMaule Flight Inc · Moultrie, GABuilt 1996 · S/N 25006CN1045RKersting Thomas J · Volga, SDBuilt 1998 · S/N 21042CN1047UStueve'S Certified Organic Dairy · Oakdale, CABuilt 1998 · S/N 23043CN1047YDonato Deleonardis · Paulden, AZBuilt 1997 · S/N 25016CN10481Marshburn Leroy D III · Kernersville, NCBuilt 1998 · S/N 21036CN10485Gold Rush Air LLC · Anchorage, AKS/N 23042CN1048FWard Anthony · Paige, TXBuilt 1997 · S/N 21013CN1048QTaf Aerial Services LLC · Corpus Christi, TXBuilt 1997 · S/N 21034CN1048TTrotter Thomas J · Bremerton, WABuilt 1997 · S/N 23037CN1048XRaven Aircraft LLC · Waynesville, OHS/N 25043CN1049ZMandan Enterprises LLC · Chester, CTS/N 21004CN1050RWatrous Scott A · Warrenton, VABuilt 1998 · S/N 21044C
Back to AD 98-15-18 R1