AD 79-10-14 R1
Registered aircraft · 56,582
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-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N8924VDupree Johnny · Crossett, ARN8924XPrevo Jerry L · Anchorage, AKN8925XMuetterties Eric Joseph · Dublin, CAN8926BEmery Marilyn L · Randle, WAN8926SRichardson Gordon P · Polson, MTN8926TBowlin George E · Roanoke, INN8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLN8926XNelson Bobby E · Naples, FLN8927BSale Reported · Crystal, MNSale reportedN8927TRockfish Ventures LLC · Wilmington, NCN8927URoberts Colton C · Bluebell, UTN8927VTropical Aviation LLC · Gulf Shores, ALN8927XSkydive Mid America LLC · Macon, MON8928SFaith Flight LLC · Hopkinsville, KYN8929BB&L Air Inc · Princeton, TXN8929UKrushinski Joseph M · Stafford, VAN8929XDivan Jeremy · Castle Rock, CON892BVGd Aviation Inc · Belleair, FLN892CPCivil Air Patrol · Maxwell Afb, ALN892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN8930BJohnson Kenneth J · Red Bluff, CAN8931GJordan Robert Nelson · Oakdale, LAN8931TAircraft Partner Holdings Inc Trustee · BerlinN8931VAeroventures 8 LLC · Mt Carmel, TNN8931XBelding Kirk A · Grass Valley, CAN8932VEverett William M · Tuscumbia, ALN89337Davis Andrea E · Lake Oswego, ORN8933SHempy David B · Lexington, KYN8933XSnyder Mark · Norwood, CON8934BPennington Clifford H · Mount Washington, KYN8934GCallender Andrew T · Howard City, MIN8934VUniversal Aviators Academy Inc · El Monte, CAN8935GHagouel Yehouda · Reseda, CAN8935MGoldberg Alan N · Point Clear, ALN8935SRegistration Pending · Mesa, AZRegistration pendingN8936BPitman Marvin L · Harrah, OKN8936SWings Over Texas Holdings LLC · Denton, TXN8937BBradley James M · Fort White, FLN8937GRussin William A · Gurnee, ILN8937VCowden Steven B · Bellingham, WAN8938GTenore William H · Lyons, CON8938SBallou Skies Aviation Inc · Bucyrus, OHN8938UJofredo Corp · Zephyrhills, FLN8939GIms Aviation LLC · Kawkawlin, MIN8939TFeeny Daniel J · Townsend, MTN8939VBray Bradley DBA · North Charleston, SCN893AFAmeriflyers Of Texas Inc · Addison, TXN893CPCivil Air Patrol · Maxwell Afb, ALN894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeN8940BFlamini Matthew D · Thompsons Station, TN
Back to AD 79-10-14 R1