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.
N70387Becker Flying Service Inc · Hartington, NEN7038EBrainerd Phillip S · Lake Placid, FLN7038GRoeder Blaine W · El Prado, NMN7038QSchenone William M · Mattituck, NYN7038TNostdahl Robert W · Bottineau, NDN7038XBrown Timothy J · Madison, SDN70391Sutton Aircraft Salvage LLC · Palmer, AKN70392Gateway Flying Club Inc · Blaine, MNN70394Halford Richard W · Eagle River, AKN7039FWharam Glen A · Park River, NDN7039GWood Donna L · Wisconsin Dells, WIN7039MFurdal Lukasz · Hillsborough, NJN7039SHotel Sierra LLC · Madison, WIN7039XOlson Scott G · New England, NDN703AGRegistration Pending · Moorcroft, WYRegistration pendingN703BFTextron Aviation Inc · Wichita, KSN703BKKenzy 2023 LLC · Castle Rock, CON703CPCivil Air Patrol · Maxwell Afb, ALN703LULiberty University · Lynchburg, VAN703MMGuidry Kirby J Jr · Blanco, TXN703SPFlightline LLC · Lewes, DEN703VPCaribbean Air Partners LLC · Winter Garden, FLN703ZSibert Gerald R · Tacoma, WAN70403Mccormick Eugene C DBA · Tyler, ALN7040EPegasus Royalty Group LLC · Bozeman, MTN7040FVtf LLC · Winter Haven, FLN7040MHood Shawn D · Weatherford, TXN7040QOrlandi Properties LLC · Blairstown, NJN7040SPro Plus Holdings LLC · Gillette, WYN7040TLesko Shannon Lt · Loves Park, ILN70411Charlie Lima 1 LLC · Jacksonville, FLN70413Lake Elmo Aero LLC · Lake Elmo, MNN70416Mcgee David · West Monroe, LAN7041AOfarrell Scott T · Seattle, WAN7041EDykstra Wayne A · Pipestone, MNN7041GJohnson Justin Eric · Grand Forks, NDN7041QElizabeth City State University · Elizabeth City, NCN7041SMaclean John A · Glenview, ILN7042AGuilbert Gerald L Jr · Fairfax, VAN7042EBennett Cass · Oxnard, CAN7042FKadlecovic Martin · Prescott, AZN7042G7042g LLC · Shingle Springs, CAN7042QWatts Ruiz LLC · Waco, TXN7042SNuernberger Howard P · State College, PAN7042XSale Reported · Larwill, INSale reportedN70438Sneller Heath E · Annandale, MNN7043ETri State Airmotive LLC · Berryville, ARN7043QNelson Christopher J · Hayfield, MNN7043SBaughman Jeffrey S · Keller, TXN7043XMile High Flight Club Inc · Miami, FL
Back to AD 79-10-14 R1