OpenAirDocs.org
AD 81-04-05 R1

Registered aircraft · 1,079

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:81-04-05-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:81-04-05-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.

N44PTDaedalus 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-297N4758PCole Gary L · Richmond, TXBuilt 1960 · S/N 27-274N4782POlson Allan K · Tarpon Springs, FLBuilt 1960 · S/N 27-338N4799PPlayer Dennis · Union Bridge, MDBuilt 1960 · S/N 27-359N47EEGt Aviation Solutions LLC · Mount Juliet, TNS/N 27-2009N47MKAztec Aviation Two LLC · Augusta, GABuilt 1973 · S/N 27-7305122N47RLUpstate Aircraft Leasing LLC · Wilmington, DEBuilt 1970 · S/N 27-4582N4823PWilliams Charles S · Pearland, TXS/N 27-389N4833PPacifica LLC · Grand Junction, COS/N 27-401N4843PSherrill L H · Tucson, AZBuilt 1961 · S/N 27-414N4851PTwin Air Assets LLC · Casper, WYBuilt 1961 · S/N 27-424N4853PSwan Aviation Ministries Inc · Baker, FLS/N 27-426
Back to AD 81-04-05 R1