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.
N4814CKingsky Flight Academy LLC · Lakeland, FLN4814DAir Puerto Rico Corp · Aguadilla, PRN4814ESchwartz Andrew T · Bethesda, MDN4814UHash Marshall T · Inglis, FLN4815Ober John A · Candor, NYN4815CSt Pete Aviation Services LLC · Saint Petersburg, FLN4815DBodeen Lance A · Eagle River, AKN4816RA&C Ag Aviation Inc · Unadilla, GAN4816VCollins Lisa A · Lake Dallas, TXN4817DWirt James · Goldsby, OKN4818DBald Eagle Flying Club · South Portland, MEN4818XSchmitt Justin M · Shawneetown, ILN4819GVeer Aviation Tx LLC · Houston, TXN4819NSilva Robert · Davis, CAN4819QPuryear Rodney K · Pampa, TXN481CGGill Christopher W · Aiken, SCN481CPBlue Water Aviation LLC · Oakman, ALN481DGrey Goose LLC · Wasilla, AKN481EREmbry-Riddle Aeronautical University · Daytona Beach, FLN481HWilliams Stephen C · Georgetown, MEN481JCollins Jason · Mansfield, OHN481PMoody Bible Institute Of Chicago · Spokane Valley, WAN481QAdams Eddie · Senath, MON481TRBowen Tim S · Robstown, TXN481USalter 11x LLC · Duluth, MNN4820DBledsoe Duane C · Glendale, AZN4820EHogan Mark C · Sisters, ORN4820GAckerman Garry · Plano, TXN4821USouth Side Corp · Loomis, NEN4822DRegistered aircraftN4822GHighpoint Strategies LLC · Cypress, TXN4822NBalinski Stephen W · Lusby, MDN48233Miller Robert S · Mesa, AZN48237Yoder Airways LLC · Fayetteville, GAN4823VStratus Air LLC · New Orleans, LAFirst renewal noticeN4823XVon Bernewitz David A · Myersville, MDN4824FWheeler Michael P · Declo, IDN4824GHickman Robert B · La Follette, TNN4824XPowell Kevin D · Nampa, IDN4825DHitec Construction Services Inc · Lincoln, CAN4825EParis Enterprises LLC · Atlanta, GAN4825FLober Richard M · Bishop, CAN4825NBlue 79 LLC · Loogootee, INN4826DTurbine Training Center Inc · Manhattan, KSN4827DWebber David A · Delta Junction, AKN4827UHagen Rainer · Irving, TXN4827XPpy Fly Corp · Atlanta, GAN4828DNisbet William T · Driggs, IDN4828PFlying Nam LLC · Sheridan, WYN4828XGillette David L · Carrollton, TXFirst renewal notice
Back to AD 79-10-14 R1