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.
N9939XGrant Matthew D · Alvord, TXN9939ZRiver Front Akn LLC · Anchorage, AKN993CPCivil Air Patrol Inc · Maxwell Afb, ALN993DWDeadstick Holdings LLC · Laguna Niguel, CAN993GAUtopia Flyers LLC · Utopia, TXN993KTFirst Air Service LLC · Show Low, AZN993PDCertified Aviation LLC · Morristown, NJN993PPCc Bar Ranch LLC · Texarkana, TXN9940ESaint Louis University · Saint Louis, MON9940MSofinme LLC · Missoula, MTN9940VSoco Aero Leasing LLC · Santa Rosa, CAN9941BBrinkley Christian D · Minneapolis, MNN9941MAlaska Aircraft Leasing LLC · Silverdale, WAN9941VMorris Gray S · Chugiak, AKN9941ZParagon Air Group · Fort Worth, TXN9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeN9942QWarren John Russell · Los Alamos, NMN9943ASipple Ronald W Jr · Gardner, KSN9943ELerud Peder E · Stockton, CAN9943MBristol Bay Air Service Inc · Dillingham, AKN9943QGrove Todd M · Lake Stevens, WAN9943VNewsom John · Lubbock, TXN9943XN63e LLC · Fallon, NVN9943ZState Of Maine Department Of Agriculture · Old Town, MEN99442Sale Reported · Kissimmee, FLSale reported, pending cancellationN9944ESw Aviation LLC · Norman, OKN9944NJungclaus Karl F · Piedmont, SDN9944QSkywarrior Flight Training Inc · Pensacola, FLN9944RCentral Virginia Aviation Inc · North Dinwiddie, VAN9944VHinkes Michael T · Fairbanks, AKN9944XChristian Dana J · Bozeman, MTN9944ZChaparral Air Group · Grapevine, TXN9945EWilcox John C · Aurora, NEN9945HCbw Holdings LLC · Columbia, TNN9945QClassic Air Aviation LLC · Mesa, AZN99465Farzam Hamid · Newington, CTN99467Civil Air Patrol Inc · Maxwell Afb, ALN9946BFuehrer John G II · Ephrata, PAN9946ELorenz Gary W · La Mesa, CAN9946MGrant Aviation Inc · Anchorage, AKN9946QHorizon Aviation LLC · Sinclair, MEN9946TKruger Matthew J · Pine Island, MNN9946XBarber Edward G Jr · Anchorage, AKN9947BClarke Adam M · Lompoc, CAN9947EAstle James H · St John, KSN9947GArthur Aviation LLC · Arthur, NDN9948AHoatson Larry · Yucaipa, CAN9948MGrant Aviation Inc · Anchorage, AKN9948TMoulton Robert J · Filer, IDN9948VSchultz Vaughn P · Marysville, CA
Back to AD 79-10-14 R1