AD 79-22-01
Registered aircraft · 2,034
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:79-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-22-01')
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:79-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-22-01') 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.
N12TNEgret Aero Inc · Colorado Springs, CON130ACBilco Air LLC · Danville, ILN130VUSwords Kyle · New Albany, MSN131DWWeitz David M · Caldwell, IDN131GSStanley Gerald L · Littleton, CON131PMDodge Sean · Littleton, NHN131RAFlorida Institute Of Technology · Melbourne, FLN131RCNordman Clay DBA · Catheys Valley, CAFirst renewal noticeN131SEHouseman Steven · Chillicothe, OHN1322XGrecor LLC · Ashville, ALN132ACScott John A · Odebolt, IAN132DPKarl Mark G · Wilbraham, MAN132PAAumont Eric J · Yucca Valley, CAN132PJPierson Ted · Gooding, IDN133JFWindsock Capital LLC · Bertram, TXN133NO'Brien Daniel R · Naples, FLN133PJAmerican Liquid Concentration Operations LLC · Lewes, DEN134MAMike Alpha LLC · Lewes, DEN134RCScout Aviation LLC · Twin Falls, IDN135DLOver And Under Flying Service Inc · Knox, INN135TMMowbray Jerry H · Reno, NVN136ACPreacher John R · Jackson, GAN137ACHare Michael Aubrey · Foley, ALN137JWNetwork Sales & Leasing Inc · Newtown, PAN138ACZimmerman Gerald M · Savannah, GAN138GBBurgan Grover W · Jacksonville, FLN139ACDavis Mark A · Lubbock, TXN139BCTrombley Steven T · Worland, WYN13JHL J H Consulting LLC · Greenleaf, IDN13PMFly High Aviation LLC · Melrose Park, ILN13RHChrist Graham Charles · Mandeville, LAN13WLRegistration Pending · Bristol, SDRegistration pendingN141BCAtkinson Air LLC · Dixon, CAN141BHBob Hannah Aviation LLC · Caldwell, IDN141CHRegistered aircraftN141SEHydro Flyers LLC · Woodside, CAN142ACFly For Fun LLC · Rockville, MDN145ACTrusler William L · Magnolia, TXN145BCMazur Steve J · Fairbanks, AKN145RWHolder Robert W · Pittsfield, PAN146MAHong Ted · San Jose, CAN146MCGibson William V · Aberdeen, MSN1470ZBig Tree LLC · Caldwell, IDN147BCCard Logging Co Inc · Eugene, ORFirst renewal noticeN147TPPatty Wagstaff Aviation Safety LLC · Saint Augustine, FLN147TQIron Thermal LLC · Hogansville, GAN148ACMach 1 Aircraft LLC · Malibu, CAN148AKMurphy Patrick · Englewood, CON148BCWalker Dean M · Fort Collins, CON148PCSuperd LLC · Everett, WA
Back to AD 79-22-01