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.
N7837FObrien Daniel N Jr · Bellevue, WAN7837GGlass Jay Thomas · El Dorado, ARN7837UCommander Aviation LLC · Monroe, MIN7837ZBouvier Louis M III · Monticello, UTFirst renewal noticeN78385Amf Aviation LLC · Dallas, GAN78388Fortner Weston · Fort Payne, ALN7838FMcdonald Air Services LLC · Saint Johns, MIN7838KDolphin Patrick D · Kenai, AKN7838ZMonnig Hans J · Westerville, OHN78395Fgds LLC · Louisville, KYN7839GGerty Air LLC · Sidney, MEN7839XBedsole Jerry L · Elba, ALN783BGAir Shares LLC · Casper, WYN783CPCivil Air Patrol · Maxwell Afb, ALN783DGJeffery & Weiss Holdings LLC · Long Beach, CAN783ELieberg Craig M · Clear Lake, MNN783EAElevation Air Capital LLC · Janesville, WIN783EPEpic Aviation Inc · New Smyrna Beach, FLN783EREmbry-Riddle Aeronautical University Inc · Prescott, AZN783FMFmfa Inc · Wilmington, DEN783SFBremfour Aviation Group Inc · Wilmington, DEN783WWThomas Michael D · Centralia, WAN78408On The Fly Aero LLC · Ocean City, NJN7840UKay Bennie L · Brigham City, UTN7840XShaw Christopher S · Porterville, CAFirst renewal noticeN7840ZHorak Mark E · Valencia, CAN78415Griffith Richard A · College Station, TXN78417Mcelwain Russell D · Lancaster, KSN7841KJohnson Daniel K · Lampasas, TXN7841TMannon Jason L · Fontana, WIN7841ULiles Edward N · Siler City, NCN7841XKleczkowski Aaron · Santa Rosa, CAN78424Acapulco Flying Club LLC · New Brighton, MNN78428Cypher Anne K · The Dalles, ORN78429Doughty Robert M · Earlville, ILN7842CWemhoff Jason L · Coeur D Alene, IDN7842EErkert Matthew P · Lebanon, PAN7842GChildress Aviation LLC · Conway, ARN7842TRmb Helicopters LLC · Factoryville, PAN7842USelig Benjamin L · Arlington, VAN78436Vp Aviation LLC · Woodstock, NYN7843FDas Manoj Kumar · Buffalo Grove, ILN7843GFlybarely LLC · Manitowoc, WIN7843UHarkrader Aviation LLC · Louisa, VAN7843XEpidendio Peter W · Lakeport, CAN78440Boeing Employees Flying Association · Renton, WAN78441444.Com LLC · Wilmington, DEN78444Hupe John F · Wamego, KSN78445Wings Over Texas Holdings LLC · Denton, TXN7844FWise Jonathan Keith · Eden, NC
Back to AD 79-10-14 R1