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.
N48BGWhitfill Mark J · Crockett, TXN48CFRaven Girl LLC · Eagle River, AKN48EFVista Air Inc · Pacoima, CAN48FACavu Pilot LLC · Powell, TNN48FCSoarmates Inc · Missoula, MTFirst renewal noticeN48FFWingsleasing LLC · Wichita, KSN48JAJahawk Leasing LLC · Sugar Grove, ILN48JGWulvik Frederik M · Wasilla, AKN48JKKeahey Britt · Saint Joseph, LAN48KCGraham Norman J · West Ossipee, NHN48PMFreeman Robert G DBA · Baker, FLN48RGBlueskies LLC · Smyrna, TNN48VAGeiser Corbin · Little Elm, TXN48WEAircraft Guaranty Corp Trustee · Oklahoma City, OKN4900ABaum James L Trustee · Anchorage, AKN4900DCastaneda Jose · Yakima, WAN4901ASchneberger C J · Clinton, IARevoked, canceledN4902ACavanagh Michael B · Dubois, WYN4902FFlying Vikings Inc · Hayward, CAN4902RBecker Flying Service Inc · Hartington, NEN4902UWallace Randall · Stamps, ARFirst renewal noticeN4902VZweifel John M · Beresford, SDN4903AKendall Ted O · Lakeside, CAN4903DSam Air LLC · Madison, SDN4903NDroke Paul Dan Jr · Coalgate, OKN4904GC & W Aviation LLC · Trumbull, CTN4904QFoxtrot Air LLC · Highmore, SDN4904UMcdonald Patrick B · Brownwood, TXN4905CAnacapa Capital LLC · Fresno, CAN4905RFlight Level Zero LLC · Othello, WAN4905UPerformance Ag Indiana · Frankfort, INN4906DHutchison Robert T · Big Lake, AKN4906NKmq Data Acquisitions LLC · Chugiak, AKN4907RMills Spraying Service Inc · Pahokee, FLN4908GShaffer Aviation LLC · Tupelo, MSN4908Q1lowflyer Inc · Harrisonville, MON4909ANastro Kristopher Jason · Fallon, NVN4909GRed Arrow Aviation LLC · Santa Teresa, NMN4909UGarner Howard E · Bonifay, FLN4909YFremont Airways LLC · Riverton, WYN490AFEiffert Matthew T · Ukiah, CAN490CPCivil Air Patrol · Maxwell Afb, ALN490DBPatkotak Crawford · Barrow, AKN490EREmbry-Riddle Aeronautical University · Daytona Beach, FLN490LLAntel Av Corp · Lewes, DEN490NWGalvin Flight Services Hawaii LLC · Honolulu, HIN490SPSky Training LLC · West Milford, NJN491Acadiana Fixed Wing Rotor Wing Inc · Carencro, LAN4910AEverett Laurence B · Berkley, CAN4910DN4910d LLC · Delavan, WI
Back to AD 79-10-14 R1