AD 79-15-01
Registered aircraft · 4,968
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-15-01')
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-15-01')
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-15-01') 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-15-01') 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.
N10FLRandall P Roumillat · Dallas, TXN10GMAlo Aviation LLC · Titusville, FLN10HGGerardy Harlan D · Gruver, TXN10HLHoyt Robert H Trustee · Canby, ORN10HMAggst LLC · Shingle Springs, CAN10HXIjh Farm Inc · Seminole, TXN10RP4f Aviation LLC · Palmer Lake, CON10RVKoehn Shane Michael · Scooba, MSN10SBSackett Michael · Nordman, IDN10TTHays John J Jr · Denton, TXN10YSeitz William D · Gordonville, TXN10YTN10yt LLC · Missoula, MTN110BDArgus Craig J · Atlantic City, NJN110HPColt 45 LLC · Tulsa, OKN110KMCars Planes And Land LLC · Fuquay Varina, NCN110NJState Of New Jersey · Trenton, NJN110YDLloyd Clee · Canby, ORN1110SMob Aviation USA LLC · Kissimmee, FLN111NJNew Jersey Forest Fire Service · Trenton, NJN111PWKilgore Eric M · Genoa, NVN111SHRobinson Doyle K · Panhandle, TXN111VFCottle John A DBA · Watsonville, CAN111ZUsda Forest Service · Boise, IDN1120VKodiak Marine Construction · Oakley, IDN1123FUrsus Air Services · Anchorage, AKN1123UTroy Investment Co 1 L P · Brownsville, TXN1128CGibbs Wyatt R · Lodi, CAN112EWKerwin Patrick C · Redwood City, CAN1132UMjolhus Knut G · Amarillo, TXN11379Bas Part Sales LLC · Greeley, CON1137MN1137m LLC · Bentonville, ARN113AGOrban Cedric · Coral Springs, FLN113TTHaley John R · Tomball, TXN114AGRlc Aviation LLC · Ansted, WVN1155PN1155p Corp Trustee · Wilmington, DEN1157QRrc Inc · Madison, MSN1157WAdams Chad D · Dayton, ORN1158ZMoffitt Carl A · Orange, CAN115CWWhitlock Gary D · Melbourne, FLN115EL182 Flight Corp · Bronx, NYN115RPN115rp LLC · Midland, TXN1173QMoon Mitchell L · Covington, GAN1178UWaco Diamond Star LLC · Niceville, FLN117HLZosel Paul J · Bellingham, WAN117PCalvin Kyle · Wichita, KSN117UMCn Aviation LLC · Gilbert, AZN1181QFly 4 Food Inc · Wilmington, DEN1183QMacfarlane Robert D · San Diego, CAN1184QStone Gary K · Santa Ana, CAFirst renewal noticeN118RSMc Namara William M · Rancho Cucamonga, CA
Back to AD 79-15-01