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.
N7258MJj Flyers LLC · Corinth, MSN7258RMoynihan Daniel P · Hernando Beach, FLN7258SBusiness As Usual LLC · Spartanburg, SCN7258TAutry Stephen W · Durango, CON7259AHalladay Roy · Erie, CON7259EWiley Jerry Lynn · Mission, TXN7259GLuevano Eric · Huntington Beach, CAN7259MRosario Ted · Salome, AZN7259QForbes Gregory Allan · Lowell, MIN7259SSchafer Louis L · Murfreesboro, TNN7259THarrington Everett Dean · Council, IDN7259XRedtail LLC · Lafayette, CON725ASGeorgia Co Of Aspiring Flyers LLC · Clarkesville, GAN725BBScenic Concepts LLC · La Crosse, WIN725BJBas Part Sales LLC · Greeley, CON725BKAmerican Patrols Inc · Midland, TXN725ECDraco Flight School Inc · Chino, CAN725LCReeves Jerry H · Whitesburg, GAN725LULiberty University Inc · Lynchburg, VAN725LVAia Echo LLC · Henderson, NVN725PGPoplar Grove Airmotive Inc · Poplar Grove, ILN725RBBatesole William D Trustee · Walpole, NHN725RJWilliams Sol F · Jacksonville, FLN725VPTeam Negrich LLC · Osteen, FLN725ZNLaramie Flying Club Inc · Laramie, WYN7260AChristiansen Aviation LLC · Wilmington, DEN7260HN2617f LLC · Frankfort, KYN7260KAmbitious Aviation LLC · Newport News, VAN7260QNaples Flying Club Inc · Naples, FLN7260XCoutu Justin · Whitewater, CON72612Washington State Dept Of Transp · Tumwater, WAN72614Liberty Leasing IV LLC · Melbourne, FLN7261ACassity Michael D · Springfield, MON7261GKindblade Aeronautics LLC · Casper, WYN7261HMurray John Fulton III · Fort Worth, TXN7261MCox Jeff C · Newark, OHN7261QSchilling Aviation Services LLC · Salina, KSN7261ZChristiansen Aviation LLC · Wilmington, DEN7262ACf Aviation Trust LLC Trustee · Wilmington, DEN7262EStrough Jacob L · Twin Falls, IDN7262MRegistered aircraftN7262QFlikins Barbara L · Fillmore, CAN7262XFlight School Of Gwinnett Inc · Lawrenceville, GAN72639Dischler Stephen · New Lisbon, WIN7263AHillside Farms · Elaine, ARN7263GHardy Chad A · Rush City, MNN7263MGolan Shachar Yaacov · Farmington Hills, MIN7263QWyatt Barbara Louise · Cheyenne, WYN7263TScheler Thomas · Independence, ORN72647Awa Tupua LLC · Brambleton, VA
Back to AD 79-10-14 R1