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.
N79199Robbins Aviation LLC · Scottsbluff, NEN7919ENicodemus Trey M · Springfield, OHN7919GLamine Aviation LLC · Columbia, MON7919XAirheads LLC · Lake City, MIN791FAAb Prop Plane II LLC · Metairie, LAN79201Universal Aviators Academy Inc · El Monte, CAN79202Jefts Larry G · Kunia, HIN79203Chupito Sabrocito LLC · Paso Robles, CAN79204Nexgen Aviation LLC · Ennis, TXN79207Swann Tawni K · Meridian, IDN79209Prp Aviation LLC · Ocala, FLN7920BThompson Deven B · Richland, ORN7920FFalk William P · Milford, CTN7920UHudecek Robert J · Grapevine, TXN7920ZKts Spar Bay LLC · Coral Gables, FLN79212Hudson Rae Air LLC · San Marcos, CAN79213Hazelhurst Inc · Middletown, DEN79217Bone Cody A · College Station, TXN79219Caley Robert M · Green, KSN7921GTriad Aviation Academy LLC · Greensboro, NCN79220Cavu Flyers LLC · Trenton, SCN79222Davis John K · Texarkana, TXN79224Wolstenholme James L · Doylestown, PAN79227Elkins Pilots Club · Elkins, WVN79228Lowcountry Flying Club · Moncks Corner, SCN7922BManley Ronnie H · Belleville, MIN7922CKemmax Holdings LLC · Latham, NYN7922TMeadow Mountain Logistics LLC · Snowmass Village, CON7922UButler Brandon R · Redmond, ORN7922ZBrown Gary W · Abilene, TXN79233Sweeney Kathleen R · Hollister, CAN79234Aig Aeronautics LLC · San Juan, PRN79238Flightclub LLC · Jacksonville, FLN79239Custis James G · Friday Harbor, WAN7923BFishel Todd · Nineveh, INN7923EKelly Charles Michael · San Angelo, TXN7923TPop Ciprian S · Reno, NVN7923UDumont William L · Wellston, MIN79241Stanley Aero Club Gastonia Inc · Belmont, NCN79244Wings Over Texas Holdings LLC · Denton, TXN79246Farrv LLC · Ogden, UTN79248San Hui Foundation · Denver, NCN79249Wings Over Texas Holdings LLC · Denton, TXN7924GHendrickson Burke · Kent, WAN7924UDownwind Corp · Brush Prairie, WAN7924ZToothman Timothy L · Xenia, OHN79253Shipe Jacqueline M · Louisville, TNN79255Angel Piper A · Mount Airy, NCN79256Mcdaniel Donald L · Tishomingo, OKN7925BBache Harold F II · Gainesville, GA
Back to AD 79-10-14 R1