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.

N4473PSemeniuk Steven T · Houston, TXS/N 23-2018N4475PRamaswamy Gautam · Clearwater, FLBuilt 1961 · S/N 23-1997N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009N4490PWelke Aviation Inc · St James, MIBuilt 1962 · S/N 23-2012N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44PTDaedalus Flight Service Inc · P FokaiaBuilt 1972 · S/N 27-4793N45050Rav Aviation LLC · Miramar, FLBuilt 1969 · S/N 27-4271N450ASConroy Philip L · Colleyville, TXBuilt 1978 · S/N 27-7854123N4515PFlying W Leasing Inc · Bartlett, ILBuilt 1960 · S/N 27-18N4525PFlying L Aircraft Inc · Fort Denaud, FLBuilt 1960 · S/N 27-29N4528PCartagena Carlos A · Sierra Vista, AZBuilt 1960 · S/N 27-32N4529PAeroclub Management LLC · Cincinnati, OHBuilt 1960 · S/N 27-33N4531PDelta Sierra LLC · Naples, FLS/N 27-35N453CBDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-2573N4552PCape Fear Aviation Maintenance LLC · Fayetteville, NCS/N 27-58N4558PAviation Services Of Tn Inc · Dover, DEBuilt 1960 · S/N 27-64N4560PAmerican Trans Air Training Corp · Virginia Beach, VABuilt 1960 · S/N 27-66N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84N4597PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-107N4614PHull John W Jr · Palmdale, CABuilt 1960 · S/N 27-126N462TTAir Enterprises LLC · Dover, DEBuilt 1968 · S/N 27-4042N4630PGoodfellow Ian A · Palm Beach Gardens, FLBuilt 1960 · S/N 27-148N4631PO'Neill Daniel C · Tumwater, WAS/N 27-149N4636PV1 Iowa Aviation LLC · Des Moines, IAS/N 27-155N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4650PCornejo Bernard J · Elko, NVS/N 27-173N4662PCorn Michael L · Wilmington, NCBuilt 1960 · S/N 27-185N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207N467JKSale Reported · St MaartenSale reportedS/N 274209N4691PWilliamsburg Air Service · Kingstree, SCBuilt 1960 · S/N 27-220N4696PPolhemus Christopher · Carmichaels, PABuilt 1960 · S/N 27-225N4699PGv Air Inc · Medford, ORBuilt 1960 · S/N 27-227N46ERAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 27-3649N46SDPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 27-8054040N4704PCarlson Brent · Medford, ORBuilt 1960 · S/N 27-232N4705PHam Edward E · Boring, ORBuilt 1960 · S/N 27-233N4714PKropf Jacob · Halsey, ORBuilt 1960 · S/N 27-243N4724PTnt Farms · Marana, AZS/N 27-252N4728PSheppard Harold DBA · Riverton, WYBuilt 1960 · S/N 27-257N4731PBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 27-261N4750PKenefick Christopher Keith · Rosamond, CABuilt 1960 · S/N 27-288N4757PRenck Michael R · Red Rock, TXBuilt 1960 · S/N 27-297
Back to AD 88-21-07 R1