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.
N61336Evans David C · Thousand Oaks, CAN61338Flyit LLC · Camas, WAN6133DThomas Aviation · Granada Hills, CAN6133GRosebud Aviation · Gregory, SDN6133KSturguess James K · Boonville, MON61345Carlson Brent A · Shelley, IDN6134GMagruder David · Independence, LAN6134KMackenzie Stuart · Pearland, TXN61354New Vision Aviation · Fresno, CAN6135EAce Aviation LLC · Mankato, MNN6135FJr Imaging Logistics Inc · Pasco, WAN6135RStafford Michael J · Clovis, CAN61363Hulbert Stephen R · Fort Ransom, NDN61365Plane Progress LLC · Waterloo, IAN61368Department Of Inland Fisheries And Wildlife · Augusta, MEN6136ERotormate LLC · Royse City, TXN6137EPennington Mitchell T · Medley, WVN6137FWingland Inc · Los Angeles, CAN6137GPiersol Benjamin T · Honey Brook, PAN6137QJeffery & Weiss Holdings LLC · Long Beach, CAN61387Stash Ventures LLC · Virginia Beach, VAN61388Seidler Matthew J · Anchorage, AKN6138FSchlegelmilch Scott A · Elkhorn, NEN6138GStrange Keith · Lincoln, MEN61398Ali Rizwan Rajab · Richmond, TXN6139BFelker Gary L · Odessa, TXN6139EWarner Aviation LLC · Belding, MIN6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeN6139TGrad Jonathan P · Warroad, MNN613ADhs Operations LLC · Wilmington, DEN613AKNorman Scott E · Anchorage, AKN613ERTextron Aviation Inc · Wichita, KSN613LGRidgeline Assets LLC · Wilmington, DEN613PFGeorgia Forestry Commission · Macon, GAN613SPAirmart Inc · Lexington, KYN613TLSams Aircraft LLC · Fredonia, KYN613WCAmpaire Inc · Hawthorne, CAN613WDCruse Josiah L · Rainier, ORN613YHKuspuk School District · Aniak, AKN61405Rovey George A · Cove, ORN6140EIorio Jeffrey M · Tucson, AZN6140FFluno John I · San Rafael, CAN6140GSmoketown Flight Center LLC · Smoketown, PAN6140KHepner Glenn L · New Port Richey, FLN6141BPayne Jacqueline · Minden, NVN6141EAbpz LLC · Mc Veytown, PAN61422Atp Aircraft 1 LLC · Wilmington, DEN61423State Of Utah · Salt Lake City, UTN6142EHabecker David A · Tecumseh, MIN6142KCreamer Ryan Patrick · Tower Hill, IL
Back to AD 79-10-14 R1