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.

N12CHKetchum Christensen Sky Chasers LLC · Midwest City, OKBuilt 1966 · S/N 18257291N12CYYeagle Aviation Inc · Port Saint Lucie, FLBuilt 1971 · S/N 310Q0247N12DKTim Cross Aviation LLC · Tucson, AZBuilt 1967 · S/N TE-290N12DMIsland Airways LLC · Marion, WIBuilt 1976 · S/N 18502947N12DUWoodtick Summit Aviation LLC · Redmond, ORBuilt 1979 · S/N U20605202N12EMMcneill Matthew C · Phoenix, AZBuilt 1966 · S/N CE-91N12ERPropelling The Gospel Missions Inc · Standish, MEBuilt 1976 · S/N 28-7615099N12FGEchols Mill Aviation LLC · Elberton, GABuilt 1998 · S/N E-3219N12FHR&B Leasing And Finance LLC · Fresno, CABuilt 1956 · S/N DH-63N12FJClement Nicolas · Littleton, MABuilt 1973 · S/N 18261732N12FMDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816439N12FSLawley Frederick E · Bozeman, MTBuilt 1966 · S/N 30-1226N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422N12HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020131N12HMRigsby Robert A · Burien, WABuilt 1956 · S/N D-4740N12HWMoonfly Inc Trustee · Wilmington, DEBuilt 1981 · S/N 25-0557N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12JGVosworx Aviation LLC · Morrison, COBuilt 1979 · S/N P21000365N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12JMMroz Kaitlin J · Rhome, TXBuilt 1961 · S/N 17248841N12JZSky West Aviation Inc Trustee · Albuquerque, NMS/N 25-1108N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915N12KCHeath David A Trustee · Cottonwood, AZBuilt 1965 · S/N D-7867N12KFN12kf LLC · Pass Christian, MSBuilt 1973 · S/N 21059853N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774N12KSWalton Cheryl H · Indianapolis, INBuilt 1974 · S/N TE-1005N12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12MTRegistration Pending · Mount Vernon, IARegistration pendingBuilt 1978 · S/N TC2119N12NBFarrell Richard A · Dacono, COS/N 55815N12PFRucker Gary R · Kingman, AZBuilt 1977 · S/N 21062401N12PJLarrabee Joey S Trustee · Holyoke, COBuilt 1979 · S/N 28R-7931105N12PMFlying Bald Eagles Inc · New Lenox, ILBuilt 1964 · S/N D-7514N12PSMurphy Peter · Johns Creek, GABuilt 1981 · S/N 44-8107047N12PWOhio State University College Of Engineering · Columbus, OHBuilt 1972 · S/N 21059796N12RCSkipper Thomas · Coburg, ORS/N D-9308N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N12RFMckay Jonathan S · Chesapeake, VAS/N 21057612N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TPTravels With Trip LLC · Lewes, DEBuilt 1961 · S/N D-6710N12TTThoms Robert D · Clyde, MIS/N 310H0066N12TYSewell Roger C · Meridian, IDBuilt 1960 · S/N 17248030N12VLCrow Edward N Jr · Silverdale, WAS/N 310P0171N12VMS & R Air Inc · Asheville, NCBuilt 1977 · S/N 21061697N12WDHamburg Jeffrey · Corsica, SDS/N 57480N12WLLauterbach Christian · Carmel, CABuilt 1975 · S/N TC-1870N12WRJjc Flyers LLC · Gladwin, MIBuilt 1975 · S/N 18263552
Back to AD 98-21-21 R1