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.
N60250Camelot Aviation LLC · Wilmington, DEN60254Holladay Aviation LLC · Jacksonville, FLN60257Ouzounov Kaloian G · North Miami, FLN6025ACullen Aviation LLC · Lafayette, LAN6025BBetter Air Service LLC · Dailey, WVN6025DMorgan Joel E · Mcalester, OKN6025GBenitez Marlin A · Potomac, MDN6025JFasking Daniel M · Stanford, ILN60266Registered aircraftN60267Butterfield Rory Arden · Milan, NMN60269Daufuskie Aerospace LLC · Daufuskie Island, SCN6026NWildcat Flying Service Inc · Lakeland, FLN6026SPhoneix East Aviation LLC · Daytona Beach, FLN6026ZAerodynamic LLC · Aurora, ORN60273Selover Terry D · Madison, WIN60279Tensco Inc · Twin Falls, IDN6027JPark William G · Canby, ORN6027RHunt Ronald L · Crystal Lake, ILN6027ZSpacely Space Sprockets LLC · Aurora, ORN60288Weatherford James L · Clarksville, TNN60289Warburton Frank W · Ware, MAN6028AHafner Karl · Fulton, NYN6028GVyatkin Denis · Sacramento, CAN6028NBernhard Mark J · Alamo, CAN6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRN60290Brooks Adam B · Palm Desert, CAN60292Bryan Stu L · Winlock, WAN60296Hage Randal M · Inwood, IAN60297Black Wyatt D · Fort Jones, CAN6029AHofer Phillip · Choteau, MTN6029JBevc Dimitri · Pleasanton, CAN6029RLamb Stephen R · Myton, UTN6029TMartling Brian W · Goddard, KSN602BBHeinke Jon B · Seymour, WIN602CPCivil Air Patrol · Maxwell Afb, ALN602EREmbry Riddle Aeronautical University Inc · Prescott, AZN602JYN13303 LLC · Miami, FLN602LTKincaid James B · Hamilton, MTN602NDRainer Flight Service LLC · Renton, WAN602SOzark Flyers LLC · Sullivan, MON602SFOffut Ancel M Jr · Madison, ALN602TCSanderson Kimberly L · Swartz, LAN602TLCoast Flight Training And Management Inc · San Diego, CAN602WPKilpatrick Matthew R · Baton Rouge, LAN602YMSawtooth Aviation Resources LLC · Ketchum, IDN60305Gil Augusto M · Hialeah, FLN60307Jstream Lc · Sheridan, WYN60314Dallison Noble S · Bentonville, ARN60315Thurston David H · Noblesville, INN6031BPizzato Alberto · Gresham, OR
Back to AD 79-10-14 R1