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.
N5857GWhitver Jeremy W · Ankeny, IAN5857RWaypoint Equipment LLC · Mckinney, TXN58580Trgn LLC · Charleston, WVN58582Hunsaker Joshua James · Turner, ORN58583Triesch Charles · Houston, TXN58586Bullock Gary L · Saint Regis, MTN5858AMadey Benjamin · Ghent, NYN5858RNitz Terry L · Fredericksburg, VAN5858TAircraft Guaranty Corp Trustee · Oklahoma City, OKN58591Blue Skies Aero Club · Redmond, WAN58593North Kern Aviation Inc · Wasco, CAN58597Smith John N · Martinsville, INN5859BGrant Marsall M · Truckee, CAN5859EFee Eamon · Winchester, MAN5859JWillis Tyler L · Wasilla, AKN585AMPj Aviation LLC · Richmond Hill, GAN585BBStrickland Tracy · Driggs, IDN585CMMandes George J · Homer, AKN585CPCivil Air Patrol · Maxwell Afb, ALN585DBCoppeta Alfred J · Altoona, PAN585PMN585pm LLC · Worthington, OHN585RDBravo Aircraft LLC · Alpharetta, GAN585ZDairy Air LLC · Van Nuys, CAN58601Baker Ranches Inc · Baker, NVN58602Leatherwood Aviation LLC - Rs N58602 · College Station, TXN58607Pendlebury David A · Pittsboro, NCN5860AMrd Aero LLC · Manheim, PAN5860ENeary John R · Ridgefield, NJN5860FThomas Kirk F · Corpus Christi, TXN5860GRegistered aircraftN5860JMcclain Kevin D · Westminster, CAN5860RSkyhawk Ventures LLC · Boise, IDN5861ETeets Trent D · West Fargo, NDN58620Ries Farms LLC · Hastings, MNN58624Hoefer Bradley W · Steamboat Springs, COFirst renewal noticeN58626Rainbow Flight Inc · Felda, FLN58628Alste LLC · Seattle, WAN5862ASanders Mark R · Towner, CON5862BJac & Phill Corp · San Ysidro, CAN5862JChase Benjamin A · West Chesterfield, NHN5862RMcgowan Keegan M · San Antonio, TXN58631Strickler Hayden B · Euclid, MNN58633Trisha Parker Real Estate Inc · Port Angeles, WAN58634Poutre Robert P · Osceola, WIN58635Decourley Claudette · San Diego, CAN58636Adventist World Aviation Inc · Wilson, NCN5863ADabney Richard W · Tanner, ALN5863BBales Charles F · Altadena, CAN5863EAj Financial LLC · Sachse, TXN58641Goodell Scott W · Humboldt, IA
Back to AD 79-10-14 R1