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.
N7925VBobcat Scout LLC · Whitefish, MTN79260Sale Reported · Xxx, OKSale reported, pending cancellationN79263Warner Richard M · Yellow Springs, OHN79264Vande Griend Scott M · Springfield, MON79268Hunt-Thornton Trevon · Aurora, CON79269Thomas Michael J · Eagle River, AKN7926BRussellaire LLC · Holt, FLN7926ELtg Enterprises LLC · Fort Wayne, INN7926FRandolph Wallie R · Nebo, NCN7926GSpencer Aviation Inc · Delaware, OHN7926VDoerstling Alexander Wolfgang · Waco, TXN79270Jb Flight Services LLC · Carlsbad, NMN79274Olson Karl C · Bethel, MEN79275Briggeman Benjamin Andrew · Indianapolis, INN79276Burkholder Bruce B · Rockingham, VAN79277Foerster Keith A Trustee · Mound, MNN7927GUrban Aviation Services Inc · Paxton, MAN7927TEaton Danny E II · Trinity, NCN7927XWhitefeather Aviation LLC · Creston, OHN7927ZKoehn Marshall C · Winton, CAN79283Bradley Flying Association · Peoria, ILN79284Wright William T · Lenoir, NCN79286Aberdeen Pilots LLC · Boerne, TXN7928BDawson Lynn M · The Villages, FLN7928FCelestial Kinetics Flight Academy LLC · Waupaca, WIN7928UPerson John · Wichita, KSN7928VCamp Harper LLC · Houston, TXN79296Ennis Michael J · Eminence, MON79297Bas Part Sales LLC · Greeley, CON7929BEvergreen Recreation Club Inc · Gainesville, TXN7929GJenkins Joseph J Jr · Matthews, NCN7929TFirst State Ag Air Inc · Viola, DEN7929VWatsabaugh Byron D · Gillette, WYN792FAAb Prop Plane II LLC · Chicago, ILN792GWSmith Brothers Aviation LLC · Bryan, TXN792MD150th Aero Flying Club Inc · Morristown, NJN792SALynn John R Jr · Laconia, NHN792SPUniversity Of Alaska Anchorage · Anchorage, AKN79300Cook Aero Services LLC · Tremonton, UTN79302Avco Patrol LLC · Lyndon, KSN79306La Partnership · Billings, MTN79308Alms Derek · Sullivan, ILN7930BWurtz Jakie Jr · Redfield, SDN7930EHeck Jean M · Colorado Springs, CON7930GRaney Wayne L · Hoxie, KSN7930VHague Neil C · Wichita, KSN79310Erkie Bryan A · Denison, TXN79312Foote Jerry O · Unadilla, NYN79314Jacobson Wayne S · Bowbells, NDN79315Waco Aircraft Partners LLC · Mc Gregor, TX
Back to AD 79-10-14 R1