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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N20CGHyco Industrial Ltd · Houston, TXN20XLTwin Bat Plane LLC · Tupelo, MSN210MKKhosravi Muhsin · Kansas City, KSN214CKBreland Michael · Olympia, WAN21FHWalker Kevin D · Tres Pinos, CAN222NMBlue Sky Air LLC · Norcross, GAN22AJBranche Gregory A · Ithaca, NYN22BKAday B Joe · Las Cruces, NMN22KJb Earthmoving Equipment LLC · Lemont Furnace, PAN230BBBishay Motors & Leasing Inc · Norwood, MAN23553Uandmycar.Com Inc · Plattsburgh, NYN23588Bunn Enterprises Inc · Fleming, OHN23PLNewsome Jeff · Blackwell, OKN242MFTruair LLC · Chaska, MNN24DHJohnson Dean Scott · Chanhassen, MNN25DAAviation Trust Company LLC Trustee · Oklahoma City, OKN265DDebalco Enterprises Inc DBA · Colorado Springs, CON268RCGraor Robert A · Las Cruces, NMN2770ASealane LLC · Burlingame, CAN2883WAustin Richard K · Ludington, MIN2889WAviation Institute Of Maintenance · Virginia Beach, VAN294DTrant David B · Kingsville, TXN2ASSupkis Daniel E Jr · Houston, TXN2GPPlanes Of Fame Air Museum · Chino, CAN2JEAircraft Guaranty Corp Trustee · Oklahoma City, OKN3036WSpowart James F DBA · Huntington Beach, CAN3055WChaney George · Hazard, KYN306QCAmerican Woodcraft LLC · Labelle, FLN30K9g LLC · Centerville, TNN30MMHilton Heli LLC · Wilmington, DEN311ANValiair Ltd Co Trustee · Casper, WYN311NSimmons Calvin L · Peralta, NMN316EWhiskey Papa LLC · Denver, CON322RJAero-Mobil Inc · Wilmington, DEN323PWWiseman Aviation Inc · Flagstaff, AZN326TCAlvarado Ruben Jr · Brownsville, TXN3344DBoyd David S · Brooklyn Park, MNN335DLarson Ken · Lake Havasu City, AZN33WFReardon Randy L · Sedalia, CON341DSl Jet D LLC · Harrison, TNN3456AEl Aviation LLC · Alpena, MIN345YWImpact Real Estate Group LLC · Casper, WYN360AKLindquist Scott DBA · Minnetonka, MNN3669DCvf Aviation LLC · Paoli, INN3675DS & L Air LLC · Torrington, WYN368BWYarak Six LLC · Berkeley, CAFirst renewal noticeN3694DAircraft & Interiors @ Klns Ltd · Brownstown, PAExpired dealer, pending cancellationN3707XDe Anza Building & Maintenance Inc · Los Altos, CAN37DBCentral Virginia Aviation Inc · Petersburg, VAN3876CSoar International LLC · Olive Branch, MS
Back to AD 83-08-05