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.
N6313EGottshall Curt E · Monroe, WAN6313FTeens In Flight Inc · Palm Coast, FLN63145Morin James R · West Ossipee, NHN63149Aviation Trust Co LLC Trustee · Oklahoma City, OKN6314AGarletts Frank · Jackson, MSN6314BGregg Delvin K · Durango, CON6314CC4p LLC · Jackson, TNFirst renewal noticeN6314DSaghafi Jamsheed Trustee · Parma, OHN6314EWeber Tom L · Douglas, WYN6314GKing William E · Simpsonville, SCN63150Parrish Jonathan · Boulder City, NVN63154Burleson James G · Grand Prairie, TXN63155Morten David J · Larimore, NDN63157Tadres Abanob Y · Antioch, TNN6315APerkins Larry L · Wildomar, CAN6315BEbright Sean E · Hasty, CON6315FSavidge Lenice M · Rogers, ARN6315SDelta Delta Aviation Group Inc · New Castle, DEN63165Eagle Eye Aviation LLC · Mccomb, MSN63166Chucks Aircraft LLC · Hartland, MEN63169Spinola Hernandes M · Homestead, FLN6316DRuiz Edinson · Bakersfield, CAN6316GChurch Aviation LLC · Christmas Valley, ORFirst renewal noticeN6316SGlobal Navigator LLC · Anacortes, WAN63174Evans James II · Seattle, WAN63177Christiansen Aviation LLC · Wilmington, DEN63179Fetch Carl Jr · Monongahela, PAN6317DJkg LLC · Murfreesboro, TNN6317GChristiansen Aviation LLC · Wilmington, DEN63180Hall Thomas E · Sylvia, KSN63181Wild Blue Flight LLC · Ellensburg, WAN63186Branche Mitchell J · Winter Haven, FLN6318AElliott Dave P · Boulder, CON6318BCenturion Associates 2 LLC · Elgin, SCN6318EEvans Robert W · Upland, CAN63197Deangelis Kristopher M · Las Vegas, NVN63198White Hayden · Lees Summit, MON63199Winfred & Waters LLC · Georgetown, TXN6319BAtarah LLC · Tucson, AZN6319FAbidance Inc · Winthrop, WAN6319KStemmer Kenneth Edward · Palm Desert, CAN631AAAerospring Leasing LLC · Wasilla, AKN631AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN631CPCivil Air Patrol · Maxwell Afb, ALN631CTCoast Flight Training And Management Inc · San Diego, CAN631EHHuddleston Edward L · Oaktown, INN631SLee Grant L · Dallas, TXN63205Bagwell Robert B · Sequim, WAN63207Two Star Maritime LLC · Fremont, CAN6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FL
Back to AD 79-10-14 R1