AD 82-23-01 R1
Registered aircraft · 3,118
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:82-23-01-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:82-23-01-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.
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:82-23-01-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:82-23-01-R1') 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.
N128LBWareham Andrew John · Wasilla, AKN12FSLawley Frederick E · Bozeman, MTN12MPMarcus Robert L · Dallas, TXN12RDFlying Colors Airparts Inc · Leesburg, FLN130MMMighty Mike LLC · Maysville, KYN132CTausch Roger M · Saint Charles, MIN136YJanoski David M · Fort Worth, TXN139CASquires Gregory K · Cedar Park, TXN13GPWeidner Kevin G · Bunker Hill, ILN1424NEbonaster Enterprises LLC · Slidell, LAN142CATack Kenneth W · Taft, CAN142EN142e LLC · Page, AZN143MMPalo Michael Scott · Melbourne, FLN1440XAlldredge Brad · Redlands, CAN144TLNielson Mark Allen · Willmar, MNN146PWilliams Mike C · Sonora, TXN148SBGriner Warren D · Pinson, ALN14FCJwc59 LLC · Newnan, GAN14YPHubbard Scott Edward Jr · Deatsville, ALN156DCEaton Billy J · Bridgeport, TXN156LMLoup Technologies Inc · Longmont, CON15QAQuiet Aero LLC · Fort Myers, FLN160LMMino Leonard G · Pueblo West, CON160MJFoley Robert A · Columbia, NJN161PRegistered aircraftN161REVornholt David · New Richmond, OHN162PMFrench Loren · Gypsum, CON16AMAnimal Health Supply Inc · Vinita, OKN16DPNdmi Inc · Greeneville, TNN16NJBurke Bryan E · Broomfield, CON16TWBaughman Kevin · Avinger, TXN175MBKlein Robert · North Garden, VAN178EGagan Samrat LLC · Charlotte, NCN178UDavis Roger W · Felton, DEN178XSs Aviation LLC · Sulphur, LAN17BDRegistered aircraftN17CMAbernathy Laurence K · Wills Point, TXN17CRDawn Aviation LLC · Pierce City, MON17MBAerocorp LLC · San Antonio, TXN17TARetired Aviators Flying Club LLC · Oklahoma City, OKN180MLBearden Harold H · Haleyville, ALN1901PTurner William D · Southaven, MSN1956RCorrech Jose Pedro · Cape Coral, FLN1959PTanner Greg L · Bend, ORN199JTPena Rivera Luis A · Zephyrhills, FLN19RDDennison Ronald Walton Trustee · San Jose, CAN19VSGardner James R · League City, TXN1JQJacquot Daniel C · Colorado Springs, CON1MEHall James C · Redington Beach, FLN1NTDmac Aircraft LLC · Savannah, GA
Back to AD 82-23-01 R1