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.

N2098PRegistration Pending · Granger, IARegistration pendingS/N 23-686N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396N20BUN20bu LLC · Champaign, ILBuilt 1977 · S/N 27-7754063N20DMLowe Aviation Co · Macon, GABuilt 1973 · S/N 27-7305066N2108PGlover William S · Mount Pleasant, TXBuilt 1956 · S/N 23-698N2112HAir V Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7754121N2112PHardin John M · Terrell, TXBuilt 1956 · S/N 23-703N211TNScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554037N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014N2150PWoodard Mark A · Hookstown, PABuilt 1956 · S/N 23-752N2162PLark Aircraft Leasing · Port Townsend, WABuilt 1956 · S/N 23-764N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765N2168PSmith Kevin L · Peachtree City, GAS/N 23-773N2172PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-778N2177PMidwest Environmental Products Inc · Wichita, KSBuilt 1956 · S/N 23-783N2190PN2190p LLC · Titusville, FLS/N 23-799N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808N2199PPowers Edward · Stormville, NYS/N 23-809N21AQCapiga Daniel P · North Fort Myers, FLBuilt 1973 · S/N 27-7305035N21DPPacific Fleet Aviation LLC · Rochester, NYBuilt 1978 · S/N 27-7854097N21NCBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1976 · S/N 27-7654012N2202PMacair Aviation LLC · Xenia, OHBuilt 1956 · S/N 23-812N2209PRuppel Robert E Jr · New Orleans, LABuilt 1967 · S/N 27-3788N2212PHollingshead Terry L · Flint, MIS/N 23-821N2214PMaslen Holbrook · Caldwell, IDS/N 23-823N2221PHardin John M · Terrell, TXS/N 23-830N222DUCg 340 LLC · Fountain Hills, AZBuilt 1973 · S/N 27-7305046N222EWGuzman Steven M · Port Saint Lucie, FLS/N 23-1539N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097N222UClukey David Alan · Bryant Pond, MEBuilt 1957 · S/N 23-912N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845N2239PCumbee Danny A · Geneva, ALS/N 23-848N223DAAerodrome LLC · Louisville, KYBuilt 1970 · S/N 27-4563N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849N2244PIsland Birds Inc · St Thomas, VIS/N 27-7405256N2254PTamayo Alejandro S · San Luis, AZBuilt 1957 · S/N 23-864N225HMSmithart Eric W · San Juan, PRBuilt 1963 · S/N 27-2341N2260PToliver David R · Overland Park, KSBuilt 1957 · S/N 23-870N2271PHorton Christian J · Melbourne Beach, FLBuilt 1957 · S/N 23-881N227CARa Procurement LLC · Helena, MTS/N 27-4591N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898N2288PChisum Robert · Lorenzo, TXS/N 23-899N2291PNice Flight LLC · Medford, ORBuilt 1957 · S/N 23-902N2293PGaston Stephen · Saint James City, FLBuilt 1957 · S/N 23-905N2296PTarrant County College · Fort Worth, TXBuilt 1957 · S/N 23-908
Back to AD 88-21-07 R1