OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,616

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-21-21-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-21-21-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.

N1170UBolton Bruce P · Monroe, LAS/N 25-0702N1170XMueller Anne H · Blairsville, GABuilt 1982 · S/N 24-1329N11719Relkar Holdings Inc · Newark, DEBuilt 1982 · S/N 24-1325N1171APilgrim Aero LLC · Oklahoma City, OKS/N 25-0705N1171BWarganich Daniel J · Placerville, CABuilt 1960 · S/N 47675N1171FBlohm Paul J. · Tiffin, OHS/N 17254766N1171GGivich Daniel D · Park City, UTBuilt 1982 · S/N 25-0706N1171LN1171l LLC · Newport News, VABuilt 1982 · S/N 24-1330N1171MProfessional Flyers Corporation · Wilmington, DEBuilt 1982 · S/N 24-1317N1171NGies Florian J IV · King Hill, IDS/N 24-1629N1171PRhames Curtis L · Farmington, NMS/N 24-1331N1171RHillier Jared Christian · Carthage, MOBuilt 1982 · S/N 24-1320N1171TCurrier Dustan A L · Fairbanks, AKS/N 30363N1171WEisenmenger James P Trustee · Yankton, SDBuilt 1982 · S/N 24-1256N11724N11724 LLC · San Marcos, TXBuilt 1982 · S/N 24-1327N1172FLincoln Meagan C · Kotzebue, AKBuilt 1966 · S/N 17254767N1172GSkranak James Robert · St Maries, IDBuilt 1966 · S/N 17254094N1172KDemo Salvage Inc · Calais, MEBuilt 1982 · S/N 25-0713N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672N1172PSteed William B · Winnsboro, SCS/N 23-175N1173APouk Douglas A · Saint Louis, MOBuilt 1982 · S/N 24-1333N1173BHicks Harlon Keith · Haleyville, ALBuilt 1994 · S/N 24-3326N1173FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254768N1173GN9337h LLC · Orlando, FLBuilt 1982 · S/N 25-0724N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673N1173NDicicco Lenny M · Asheville, NCBuilt 1982 · S/N 24-1335N1173QMoon Mitchell L · Covington, GAS/N 21059673N1173WScupham R K · West Des Moines, IABuilt 1983 · S/N 25-0731N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188N1174TDynamic Erp Resources Inc · Mansfield, TXBuilt 1975 · S/N TE-1056N1175Hamilton John G · Davenport, CABuilt 1958 · S/N 55185N1175MRj Freebird LLC · Driftwood, TXBuilt 1975 · S/N 18264239N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231N1177AN1177a LLC · Lewes, DEBuilt 1977 · S/N 32R-7780430N1177FSeaman Kenny James · Edgewood, TXBuilt 1966 · S/N 17254772N1177RN1177r LLC · Marshall, MIBuilt 1968 · S/N 18259162N1177SRoss Robert S · Pigeon, MIBuilt 1958 · S/N 50177N1177XParrish View Farms · Kenbridge, VABuilt 1975 · S/N 28-7510086N1178FTrue Course LLC · West Monroe, NYBuilt 1966 · S/N 17254773N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220N1179MBartholomew Thomas C · Stanwood, WABuilt 1969 · S/N 17258679N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124N1179UBadgerland Aero Club Inc · Fitchburg, WIBuilt 1976 · S/N 17266880N1179XDesch Edward J III · Aldie, VABuilt 1975 · S/N 28R-7535267
Back to AD 98-21-21 R1