OpenAirDocs.org
AD 88-21-07 R1

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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.

N2299PMoeller Wendell L · Porter, TXBuilt 1957 · S/N 23-884N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074N22ZZTreicher Peter · East Aurora, NYBuilt 1979 · S/N 27-7954043N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011N2313ZT R Gemelli Holding Co LLC · Wilmington, DEBuilt 1979 · S/N 27-8054013N2320MAkl Properties · Westlake, OHBuilt 1979 · S/N 27-7954038N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031N23ASRusso James F · Liberty, SCS/N 27-3094N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025N2454FOlson Donald C · Golovin, AKS/N 27-2666N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039N251EARegistered aircraftBuilt 1969 · S/N 27-4238N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007N25FTPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754038N25JFBuckingham James M · Palmer, AKBuilt 1968 · S/N 27-3903
Back to AD 88-21-07 R1