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.
N8713TMoreau Darlene A · Penrose, CON8713XLentz Walter E · Duncan, OKN8714TPittman Stuart P · Palisade, CON8714XFrancis Rocky D · Greeley, CON8715BSchultz John J · Kenai, AKN8715SAllen Thomas Page · Comer, GAN8715ZMarconi Joseph · Hamilton, OHN8716SBores Scott J · Huron, OHN8716TManchester International LLC · Liberty Lake, WAN8716UWings Of Hope · Chesterfield, MON8716XKempf Jerry J · Whitefish, MTN8717BNorsic Michael · Parma, OHN8717QState Of Alaska · Nome, AKN8717XStevens Matthew S · Penn Yan, NYN8717ZBoucher Kenneth G · Scotland, CTN8718UPuckett Matthew Scott · Argyle, TXN8719BSale Reported · Westerville, NESale reported, canceledN8719GRosso Anthony J · Wallace, NCN8719ZFedane Rohit · Green Bay, WIN871CPRedstone Arsenal Flying Activity · Redstone, ALN871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN871FBFreebird Leasing Group LLC · Sarasota, FLN871PDJohnson Aircraft Leasing LLC · Springfield, ILN871TSSlad George W · Albuquerque, NMN8720THarris Todd D · Malta, IDN8720XSparks Brian Elslie · Monmouth, ORN8721SPruden Larry J · Louise, MSN8722BBuell Jack A · St Maries, IDN8722QPrice Scott · Eagle Point, ORN8722TBarker Bruce L · Liberal, MON8722UBrown Stephen L · Charlotte, MIN8723GEastham Gregory L · Columbia, KYN8723SCondor Aviation LLC · South Saint Paul, MNN8723UTraining Services Inc T/A · Virginia Beach, VAN8724BMcmahon William · Westville, INN8724TStephens Nicholas C · Overgaard, AZN8724URonald O Holcomb LLC · Lapeer, MIN8725QN8725q LLC · Grand Junction, CON8725SKolis Joseph E II · Springfield, ILN8725UArklamiss Aviation LLC · Ruston, LAN8725ZRomine George · Tucson, AZN8726BEckles Phillip · Holdenville, OKN8726GJacks Benjamin Scott · Chanute, KSN8726UHowell Harley L · Colville, WAN8727GJstream Lc · Sheridan, WYN8727SMejia Jose Patricio · Meridian, IDN8727XWallis Aircraft Inc · Clifford Township, PAN8727ZRobertson Reuben · Johnson City, TNN8728XQualls Randy J · Claremore, OKN8729BChristian Melvin Lee Jr · Apison, TN
Back to AD 79-10-14 R1