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.
N5423JRialto Christian Flyers Club Inc · Bradenton, FLN5423KRandel James B III · Mill Valley, CAN5424AFudurich David E · Goleta, CAN5424JFusano Lisa A · La Crescenta, CAN5424QBeltzville Aero LLC · Lehighton, PAN5424TEshleman James E · Yucaipa, CAN5424UWsol Michael P DBA · Huntington Beach, CAN5424VSorbi Aviation Inc · El Cajon, CAN54257Meridian Airport Authority · Meridian, MSN5425AValiair Ltd Co Trustee · Casper, WYN5425BEslinger Beau T · Tucson, AZN5425KHayden Stephen M · Ludlow, MAN5425RWalker Lyle P · Katy, TXN5426CVirginia Air Inc · Roanoke, VAN5426JMedia Stew LLC · Carson City, NVN5426QLen Emery Photography LLC · Springfield, VTN5426SPetrof Karl J · Ligonier, PAN54273Swanson Gary A · Fort Bragg, CAN5427BYeary Clifton K · Quitaque, TXN5427TNw Aircraft Sales & Leasing LLC · Scappoose, ORN5427XRegistered aircraftN54285Monahan Richard J Jr · Budd Lake, NJN54288Chandler Air Service Inc · Chandler, AZN5428CSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5428QKruse Jakob · Parsippany, NJN5428SLepping Kurt · Wasilla, AKN5428TBarnes Joseph A · Upper Lake, CAN5428UCordova Air Service Inc · Cordova, AKN54290Laguna Verde Leasing Inc · Wilmington, DEN54291Flight School Of Gwinnett Inc · Lawrenceville, GAN54296Honcho Aircraft LLC · Crosby, TXN5429CHenrikson Peter R · Fort Worth, TXN5429RRose Ronald R · Richland, NYN542ADJohnson Thomas F · Buckeye, AZN542CGulf States Financial Services · Lafayette, LAN542EBSvoboda Erik S · Mentor, OHN542ECWang Warner Weihsu · Vienna, WVN542EREmbry Riddle Aeronautical University Inc · Prescott, AZN542KSKent State University · Stow, OHN542SWHardy Tracy G · Tucson, AZN542THNorthern Cowboy Holdings LLC · Prior Lake, MNN54306Aiken Patrick J · West Greenwich, RIN5430AAdams Hay Farms LLC · Cedar City, UTN5430CWilson William J · Aniak, AKN5430TReitz Enterprise LLC · Goliad, TXN54311Daniel Earl F · Ashland, KYN54319Jones Roddy H · Thomasville, GAN5431BRi Skydiving Aircraft LLC · Middletown, RIN5431SGreensburg Jeanette Airport Administration Inc · Jeannette, PAN5431TCorbett Michael T · Lake City, FL
Back to AD 79-10-14 R1