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.
N459CMIasco Flight Training Inc · Redding, CAN459CSHorizon Flight Center LLC · Chesapeake, VAN459EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN459JCBruton Bert L · San Angelo, TXN459MLKon Air LLC · River Ridge, LAN459SPAmeriflyers Of Texas Inc · Addison, TXN459STMeyers Sean · Jupiter, FLN459THHlavaty Troy Edward · Columbus, NEN45ADLen Timothy Allen · Deland, FLN45AGHogan Thomas A · Fairfield, OHN45AMThornburg Rocky R · White Hall, ARN45CSSadowski Curtis D · Taylorville, ILN45DARegistration Pending · Fairbanks, AKRegistration pendingN45DBMoler Doug · Valley Center, KSN45DSDcd Agriculture LLC · Franktown, CON45EFSvetfur Aviation LLC · Camden, SCN45ERWindmark Ridge LLC · Port Saint Joe, FLN45GVRedd Aviation LLC · Springville, UTN45KJAvondoglio Kirk D · Andover, NJN45LLLangebrake Lawrence C · Saint Petersburg, FLN45UDAlf Ix LLC · Chicago, ILN45VCHoyos Luis F · Fort Pierce, FLN45WBDfw Aero Mechanix Inc · Oak Point, TXN45WCClark John A · Louisville, MSN45WSRandazzo Meredith · Matthews, NCN45XDSubstation Air LLC · Midvale, UTN46001Df Kitcar LLC · Red Oak, TXN46003Carroll Michael L · Rochester, WAN4600BKlyde Jeremy M · Irvine, CAN4600COneill Kenneth W · Villa Park, CAN4600JDavis Robert M · Dallas, NCN4600LRitchie Edwin J · Katonah, NYN4600UDlw Aviation LLC · Missoula, MTN4600XTwo Dot Aircraft LLC · Kalispell, MTN46011Jackson William T · Clinton, OHN46015Leaders Flying Service LLC · Clear Lake, MNN46019La Porte Aero Club Inc · La Porte, INN4601BArnavair LLC · Pearland, TXN4601ETen Two Holdings LLC · Somers, MTN4601GResicum International LLC · Gulf Shores, ALN4601RMiddle Tennessee State University · Murfreesboro, TNN4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLN4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN4601XMast Aviation LLC · South Boston, VAN46024Garfield Joshua E · Tampa, FLN46027Cleary Thomas J · Fairport, NYN46028First Take Aviation LLC · Van Nuys, CAN4602WBrugueras Ralph Steven · Deer Park, WAN46030Constance Air LLC · Luthersville, GAN46031Soucy Gary J · Brewer, ME
Back to AD 79-10-14 R1