AD 83-08-05

Registered aircraft · 261

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:83-08-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-08-05')
  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.

N20CGHyco Industrial Ltd · Houston, TXBuilt 1979 · S/N P-495N20XLTwin Bat Plane LLC · Tupelo, MSS/N P-566N210MKKhosravi Muhsin · Kansas City, KSS/N P-369N214CKBreland Michael · Olympia, WABuilt 1976 · S/N P399N21FHWalker Kevin D · Tres Pinos, CABuilt 1975 · S/N P-356N222NMBlue Sky Air LLC · Norcross, GABuilt 1977 · S/N P-442N22AJBranche Gregory A · Ithaca, NYBuilt 1977 · S/N P-441N22BKAday B Joe · Las Cruces, NMBuilt 1974 · S/N P-312N22KJb Earthmoving Equipment LLC · Lemont Furnace, PAS/N P-51N230BBBishay Motors & Leasing Inc · Norwood, MAS/N P-460N23553Uandmycar.Com Inc · Plattsburgh, NYBuilt 1977 · S/N P-453N23588Bunn Enterprises Inc · Fleming, OHBuilt 1978 · S/N P-454N23PLNewsome Jeff · Blackwell, OKBuilt 1970 · S/N P-128N242MFTruair LLC · Chaska, MNBuilt 1978 · S/N P-465N24DHJohnson Dean Scott · Chanhassen, MNBuilt 1979 · S/N P-515N25DAAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N P-483N265DDebalco Enterprises Inc DBA · Colorado Springs, COBuilt 1980 · S/N P-548N268RCGraor Robert A · Las Cruces, NMBuilt 1977 · S/N P-416N2770ASealane LLC · Burlingame, CABuilt 1979 · S/N P-492N2883WAustin Richard K · Ludington, MIBuilt 1973 · S/N P-238N2889WAviation Institute Of Maintenance · Virginia Beach, VABuilt 1973 · S/N P-249N294DTrant David B · Kingsville, TXBuilt 1977 · S/N P-451N2ASSupkis Daniel E Jr · Houston, TXBuilt 1979 · S/N P-511N2GPPlanes Of Fame Air Museum · Chino, CAS/N P-56N2JEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N P-358N3036WSpowart James F DBA · Huntington Beach, CABuilt 1973 · S/N P-236N3055WChaney George · Hazard, KYS/N P-251N306QCAmerican Woodcraft LLC · Labelle, FLBuilt 1972 · S/N P-190N30K9g LLC · Centerville, TNBuilt 1973 · S/N P-255N30MMHilton Heli LLC · Wilmington, DEBuilt 1979 · S/N P-507N311ANValiair Ltd Co Trustee · Casper, WYBuilt 1970 · S/N P-141N311NSimmons Calvin L · Peralta, NMBuilt 1970 · S/N P-130N316EWhiskey Papa LLC · Denver, COS/N P-550N322RJAero-Mobil Inc · Wilmington, DEBuilt 1974 · S/N P-322N323PWWiseman Aviation Inc · Flagstaff, AZBuilt 1980 · S/N P-541N326TCAlvarado Ruben Jr · Brownsville, TXBuilt 1969 · S/N P-121N3344DBoyd David S · Brooklyn Park, MNBuilt 1975 · S/N P-344N335DLarson Ken · Lake Havasu City, AZS/N P-129N33WFReardon Randy L · Sedalia, COBuilt 1971 · S/N P-168N341DSl Jet D LLC · Harrison, TNBuilt 1976 · S/N P-397N3456AEl Aviation LLC · Alpena, MIBuilt 1977 · S/N P-443N345YWImpact Real Estate Group LLC · Casper, WYBuilt 1969 · S/N P-85N360AKLindquist Scott DBA · Minnetonka, MNBuilt 1968 · S/N P-18N3669DCvf Aviation LLC · Paoli, INS/N P-544N3675DS & L Air LLC · Torrington, WYBuilt 1980 · S/N P-546N368BWYarak Six LLC · Berkeley, CAFirst renewal noticeBuilt 1974 · S/N P-290N3694DAircraft & Interiors @ Klns Ltd · Brownstown, PAExpired dealer, pending cancellationBuilt 1980 · S/N P-552N3707XDe Anza Building & Maintenance Inc · Los Altos, CABuilt 1980 · S/N P-557N37DBCentral Virginia Aviation Inc · Petersburg, VABuilt 1974 · S/N P-309N3876CSoar International LLC · Olive Branch, MSBuilt 1979 · S/N P-513
Back to AD 83-08-05