AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N126PFPylant Ruth A · Lubbock, TXN128LBWareham 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, CON166SPSwitzer James DBA · Costa Mesa, CAN16AMAnimal 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, TXFirst renewal noticeN1JQJacquot Daniel C · Colorado Springs, CO
Back to AD 77-13-21