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.
N5129DPolatis Daniel T · Pingree, IDN5129ETjr Aviation LLC · Orefield, PAN5129QWaters John E · Renton, WAN512ADDiffenderfer Andy C · Horseheads, NYN512ATRanch Aero LLC · Sterling City, TXN512CTCoast Flight Training And Management Inc · San Diego, CAN512ERTextron Aviation Inc · Wichita, KSN512GTBarron Thomas Aviation Inc · Scottsdale, AZN512JGJacobs Gareth · Woodruff, SCN512KMWhite Holdings LLC · Washington, INN512NDCoast Flight Training And Management Inc · San Diego, CAN512RSchappert Jason M · Naples, FLN512SPAvolant Aviation LLC · Mooresville, NCN512TMSouthern Flight Aviation LLC · Bainbridge, GAN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEN513International Air Services Inc Trustee · Carson City, NVN51300Loftin Gabe · Weatherford, TXN51304Stewart Roy L · Roy, UTN51306Durand Gregory M · Marquette, MIN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130EAviation Capital Management LLC · San Jose, CAN5130FC & M Dreamflights LLC · Mount Pleasant, SCN5130RShamp Jimmy L · Fresno, CAN5130YMerritt LLC · Leesburg, VAN51313Echo Tango 03 LLC · Anthem, AZN51314Scott John J · Arcadia, FLN51316Devault Clayton D · Larkspur, CON51317Spitzer Terry E · Kalona, IAN5131AJohnson Basil · Tucson, AZN5131EBrunken Barry D · Tower Hill, ILN5131FWoerle Edward R · Rossville, TNN5131NPiedmont Aircraft LLC · North Myrtle Beach, SCN5131QLeavitt Craig S · Spicewood, TXN5131RMlt Operations LLC · Traverse City, MIN51323Rathnayake Eric · Collegeville, PAN51325Baldwin Gordon Lee Jr · Altamonte Springs, FLN51326Lapoint Paul E · Drummond Island, MIN51327Bowles Alan B · Georgetown, TXN51328Butterfield Charles D · Eskridge, KSN5132EFicklin Thomas L · Fairbury, ILN5132HMohnacs Joseph T · Mount Laurel, NJN5132QHauptman Ben · Alexandria, VAN5132RChristiansen Aviation LLC · Wilmington, DEN5132ULiberty Exploration Inc · Las Vegas, NVN51330Cortez Flying Service Inc · Cortez, CON51333Blazey John Stanley · Palmyra, NYN51334Cragg Noel J · Millbrae, CAN51337Garner Charlotte Trustee · Sun Lakes, AZN5133ALake Area Technical Institute · Watertown, SDN5133DPalmer Ross G · Las Cruces, NM
Back to AD 79-10-14 R1