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.
N92520Heartland Air Services LLC · Wilmington, DEN9252BSwain Raymond B · Mansfield, TXN9252CBartels Aaron J · Brenham, TXN9252GEmbry Aero Ltd · Greenville, ILN9252HStratus Aviation LLC DBA · Vacaville, CAN9252RBank Of Utah Trustee · Salt Lake City, UTN9252UHoffman William C · Rostraver Township, PAN92532Jones Timothy D · Cooper, TXN92534Courtney Joseph D · Livingston, LAN9253GSteiner Ivy C · Fairhope, ALN9253TMichael J Kraynick Pllc · Hailey, IDN92541Larson Alexis Kae · Bismarck, NDN92542Timing Building LLC · Wilmington, DEN92546Maracek Thomas · Middletown, CAN92548Pulliam Richard W · Henryetta, OKN9254AHattell George Curtis · Olympia, WAN9254BMcdonald Daniel R · Las Vegas, NVN9254CFlight Trainer LLC · Wilmington, DEN9254GStowe Henry L · Covington, GAN9254HShipley Donald E · Alpine, TXN9254TLuper Gary M · Anchorage, AKN9254YFlorida Memorial University Inc · Miami Gardens, FLN92551Brazos Valley Flyers LLC · College Station, TXN92554Kortsen & Associates LLC · Flagstaff, AZN92557Soto Naomi · Ocala, FLN92559Olmo William J · Priest Lake, IDN9255AHotel Security Group LLC · Duluth, GAN9255TShepp Carl R Jr · Florence, MTN92567Registration Pending · Orlando, FLRegistration pendingN9256BDillard Wendell Hoyt · Centerville, TXN92570Becker Steven H · Prescott, AZN9257ULiberty Flyers Inc · Ramsey, MNN92584Buckner Walter · Columbia, TNN9258GHerb Meloche Ltd · West Allis, WIN92593Snider Scott E DBA · Turner, MTN92595Bearfight Aviation LLC · Dover, DEN92597Morgan Ent LLC · Richland, IAN9259CHauser Linda L · Ulysses, KSN9259HBooke Phillip Austin · Anniston, ALN9259UAdirondack Legacy Aircraft LLC · Saratoga Springs, NYN925ABJavelina Trax LLC · Saint Charles, MON925CBDhani Errol · Locust Grove, GAN925CPCivil Air Patrol · Maxwell Afb, ALN925EPEpic Aviation Inc · New Smyrna Beach, FLN925JKLonghorn Listings Inc · San Antonio, TXN925MHAir America Imagery LLC · Daytona Beach, FLN925MML A M Capital Management LLC · Sheridan, WYN925PTPuddle Jumper Aviation LLC · Saginaw, MIN925RRHahn John K · Evansville, INN925WMHoward Charles M · Pittsburg, TX
Back to AD 79-10-14 R1