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.
N700RBM & J Flight LLC · Cheboygan, MIN700RWWhittington Rankin A Trustee · Lenoir, NCN70104Duclos Paul R III · Anchorage, AKN7010EVorpagel Richard H · Elkhorn, WIN7010GStavair LLC · Gulf Breeze, FLN7010QMosman Matthew J · Nezperce, IDN7010TLuft Aviation Inc · Wilmington, DEN70112Piper Meridian LLC · Mesa, AZN7011ALaursen Nancee S · Tarpon Springs, FLN7011ESimon James A · Daphne, ALN7011FGlow Medspa LLC · Spring Hill, TNN7011GChase Development Aviation LLC · Oakland Park, FLN7012EGordy Melvin E · League City, TXN7012TL L B Ranch Ltd · Del Rio, TXN7013EPerkey Dan K · Rockvale, TNN7013GSaeid Abdelmasih · Euless, TXN7013QVeil Casey J · Jamestown, NDN7013TJohnston Jeremy · Cedar Springs, MIN70141Priewe Flying Service LLC · Como, MSN70148Panting Edwin Allan · Anchorage, AKN7014AWaller John Michael · Brownsville, TXN7014ESkinner Norman D · Osceola, IAN7014THill James T · Rock Hill, SCN7015ELovato Daniel C · Springville, CAN7015GDaugherty William A · Horseheads, NYN7015MWalters Larry L · Venango, NEN70162Nwops LLC · Woodinville, WAN7016SCreed Stephen L · Hamilton, VAN7017AHodgens Phillip J · Saluda, SCN7017EWinn Larry V · Tucson, AZN7017MDoughty Robert W · Casa Grande, AZN7017QClair Michael A · Omaha, TXFirst renewal noticeN7017SGladwin Stephen R · Pflugerville, TXN7017TSchubert Arthur Glen · Wilmington, NCN70183Cranford Billy J · Wasilla, AKN7018AKilburn Daniel B · Worcester, MAN7018GCape Aerial Tours Inc · Chatham, MAN7018QStockett & Assoc Ltd · Hattiesburg, MSN7018TWarner Terry S · Grants, NMN7018XMenard Charles H · Grand Blanc, MIN70194Jelinek Spencer T · Erie, CON70195Registration Pending · Anchorage, AKRegistration pendingN70196South Shore Flying Club Inc · South Weymouth, MAN70199Motonaga Gregg K · Soldotna, AKN7019AReynolds Barbara A · Los Fresnos, TXN7019FShore Luke S · Thurmond, NCN7019QYenser Thomas A · Kutztown, PAN7019TGerdeman David R · Litchfield, OHN7019XWardwell Walter L · Fallon, NVN701BPWings Over Texas Holdings LLC · Denton, TX
Back to AD 79-10-14 R1