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.
N7341QHahn John C · Sherwood, ARN7341TG & D Holdings LLC · Provo, UTN73420Globemaster Services LLC · Saint Jacob, ILN73423Weck Geoffrey E · Woodstock, ILN73424Quincy Flying Club Inc · Quincy, ILN73425Wings Over Texas Holdings LLC · Denton, TXN73428Johnson Brent C · Appleton, MNN73429Anson Flyers Club Inc · Wadesboro, NCN7342ANewberry Ernest B Jr · Crawfordville, FLN7342KPurvis Danny J · Anchorage, AKN7342QThistlesoar LLC · Plaquemine, LAN7342TKeyes George E Jr · Moab, UTN73433Salvation Neighborhood Development Corp · Riverside, CAN73434Monette Verne G · Anchorage, AKN73435Air America Spares LLC · Daytona Beach, FLN73439Umo Flight School LLC · Mount Olive, NCN7343ACheek Kenneth W · Yadkinville, NCN7343ELemanski Joseph S · Grosse Ile, MIN7343MSheets Laura J · Follett, TXN7343XEnyart Patrick · Lindlakes, MNN73441Stein Aporn U · Pepeekeo, HIN7344MKiever Robert P Jr · Summerfield, FLN7344XOff LLC · Lonoke, ARN73450Penn Yan Flying Club Inc · Penn Yan, NYN73451Airward Inc · Columbia, CAN73452Hodges Jonathan D · Port Orchard, WAN73453Mfa LLC · Mount Pleasant, SCN73454Yr-Aircraft Leasing LLC · Soldotna, AKN73455101 Flight LLC · Waterford, MIN73456K E F Enterprises · Plymouth, MAN73457Bmg Aviation Inc · Bloomington, INN73459Stowers Joshua S · Niceville, FLN7345GJacks Air Service Inc · Greenville, MEN7345QLester Darrell S · Riverton, UTN7345XStraytail150 LLC · Minneapolis, MNN73461Monk Crafton L · Saraland, ALN73462Farkas Dan · Wyoming, MIN73464Knight Kevin J · Fort Wayne, INN73467Ryan Air Inc · Anchorage, AKN73468Tnt Airworks LLC · Hibbing, MNN7346GBentley Darrell Howard · Powell, TNN7346SWood Donald · Spring Branch, TXN7346THalford Richard W · Eagle River, AKN73472Lajova LLC · Amarillo, TXN73473Lauro Michael J · Kailua Kona, HIN73477Nationwide Aviation LLC · Hudson Oaks, TXN7347ATalkeetna Build A Plane Inc · Talkeetna, AKN7347GN7347g LLC · Miami, FLN7347NAv8 LLC · Boise, IDN7347QMitchell David L · Imperial, TX
Back to AD 79-10-14 R1