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.
N4923UUnited Indian Missions Inc DBA · Tucson, AZN4924AMachnik Todd J · Old Lyme, CTN4924DRobinson Anthony D · Brookshire, TXN4924ENorthstar E & C LLC · Anchorage, AKN4924UScheren Raymond D · Johnson, VTN4925CRichardson Richard E II · Windham, MEN4925FA S Air LLC · Lantana, FLN4925GSchwenker David W · Queensbury, NYN4925QEsty Effew LLC · Wimberley, TXN4926AEngland John James · Montrose, CON4927DGreenville Flight LLC · Greer, SCN4927NRmst LLC · Mason, OHN4927QWakefield Aircraft LLC · Cooperstown, NDN4927UBetz Brett A · Reminderville, OHN4928EAce Of Spades Aviation LLC · Las Vegas, NVN4929AApling Randall L · Wasilla, AKFirst renewal noticeN4929DUnion Flyers LLC · Union, SCN492ERWings Over Kauai LLC · Kalaheo, HIN492PCTextron Aviation Inc · Wichita, KSN492SFSnohomish Flying Service Inc · Snohomish, WAN492SPChristiansen Aviation LLC · Wilmington, DEN492WPAngel Aviation Inc · Peoria, AZN4930ACapra Cory · Forest Lake, MNN4930DToribio LLC · San Antonio, TXN4930NOneill Aviation LLC · Lake Wales, FLN4930RSouther Field Aviation Inc · Americus, GAN4931CEinstein Inc · Price, UTN4931RRegistration Pending · Westhope, NDRegistration pendingN4932ALegas David S · Phoenix, AZN4932NSan Juan Flyers Inc · Pagosa Springs, CON4933QDarter Lloyd R · Mountain Grove, MON4934AYellowstone Overflight Inc · Belgrade, MTN4934EHeineman Steven · Chicago, ILN4934USatriana Robert L · Belen, NMN4935AVucetic Miroslav · Coral Springs, FLN4935GKip'S Flying Service LLC · Bankston, ALN4935QHaygar Berlin Inc · Shorewood, MNN4936AAnderson Dennis G · Eagle River, AKN4936NSwett Alan · Panora, IAN4937GInternational Air Services Inc Trustee · Carson City, NVN4937RAllred Bobby A · Centre, ALN4939CBard Ralph M · Tullahoma, TNN4939RMiller Farms Jv · Opheim, MTN4939VFlorida Keys Flight Academy LLC · Marathon, FLN4939YDavidson Dan F · Ozona, TXN4939ZStaheli Lee E · Kiana, AKN493BTRegistration Pending · Deltona, FLRegistration pendingN493CPCivil Air Patrol · Maxwell Afb, ALN493EREmbry-Riddle Aeronautical University · Daytona Beach, FLN493JLPhoenix Flyers Inc · Mesa, AZ
Back to AD 79-10-14 R1