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.
N5323URio Farms LLC · King City, CAN53243Fly Low Aviation LLC · Ashley, NDN53245Kirk Ben C · Louisville, MSN5324GFloris Flight Services LLC · Midland, TXN5324VAviation Resources LLC · Post Falls, IDN5325BHinman Joshua D · Arcadia, CAN5325NSchindler Lawrence A · Chino Valley, AZN5325QIlm Aviation LLC · Waxahachie, TXN5325RBardo Daniel J · Salem, OHN5325SR & H Aviation LLC · Shady Shores, TXN5325YBeehive Telephone Co Inc Nevada · Lake Point, UTN53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSN53265Jeppesen Employees Flying Association · Englewood, CON5326BBoatman Charles L · La Porte, TXN5326DHiebert Nathan D · Newton, KSN5326KCornelius Aviation Inc · Mooresville, NCN53277Petecraft Aviation Services Inc · Plains, GAN5327DPiekarski John S · Wichita Falls, TXN5327GDirty Side Down Aviation LLC · Georgetown, TXN5327JEdb Air Inc · Wilsonville, ORN5327QLarsen Deziree L · Bay Point, CAN5327RMcgrath John J · Littleton, CON5327SLowry Steve H · Sun River, MTN5327TMurphy Shane T · Bird Creek, AKN5327VSouthern Illinois University · Murphysboro, ILN53289Christiansen Aviation LLC · Wilmington, DEN5328BUninsured Swope 182 LLC · Kalispell, MTN5328CLewis George F Jr · Hampton, CTN5328KAvanna LLC · Shaw Island, WAN5328TDiem James L · Kiel, WIN5328YGa Holdings LLC · Moffett Field, CAN5328ZBartow Municipal Airport Development Authority · Bartow, FLN53293Tito Hector · Fayetteville, GAN5329CVetterli Gary R · Monroe, WIN5329DMeketa Ann M · La Vernia, TXN5329RDearborn Flying Club Inc · Grosse Pt Shr, MIN5329SAlabama Forestry Commission · Montgomery, ALN5329TShort Kenneth L · Setauket, NYN532DCDc Aviation LLC · Panama City, FLN532EREmbry-Riddle Aeronautical University Inc · Prescott, AZN532HFJet Air Inc · Iowa City, IAN532NDAia Bravo LLC · Henderson, NVN5330EKrieger Andy G · Katy, TXN5330NMarion Michael · Canyon Country, CAN5330QBend Aircraft Mechanics LLC · Bend, ORN5330TMilne Sales And Services LLC · Lake Geneva, WIN5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeN53310Lucente Michael A · Fort Myers, FLN53315Denton Aerial Spraying · Las Animas, CON53319Souther Field Aviation Inc · Americus, GAFirst renewal notice
Back to AD 79-10-14 R1