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.
N94812James Hamilton Construction Co · Silver City, NMN9481AScholl Jonathan W · Mckinney, TXN9481BPueppke Clinton · Ayr, NDN9481CWhitby Christopher W · Prescott, AZN9481DBoemig Madison K · Dalton, NHN9481UParnell Jr Jerry · Panama City, FLN9481X2310 Woodcrest LLC · Freeland, PAN94823Black Hills Information Security Inc · Bozeman, MTN94825Vaughan Aviation LLC · Leesburg, VAN9482MWestwind Aviation Inc · Phoenix, AZN9482RWindy Lane Farms Transport LLC · Mulberry, INN9482UClark Josh D · Morehead, KYN9482ZChristiansen Aviation LLC · Wilmington, DEN94837Leyser Joshua F C · Tega Cay, SCN9483HDelbrocco Christopher A · Waitsfield, VTN9483YSioux Falls Technology LLC · Sioux Falls, SDN9484ABrown Glen S · Aberdeen, MSN9484CKnowles Jayson C · Winter Harbor, MEN9484HN9484h LLC · Wheeling, ILN9484XD&J Air Adventures Inc · Koloa, HIN94853Middle Georgia Aviation Services LLC · Warner Robins, GAN94854Sutliff John K · Walla Walla, WAN9485ABeam David M · Sabina, OHN9485BLuggar Michael D · Leonard, MNFirst renewal noticeN9485RStevenson Flying Service LLC · Selden, KSN9485XBruckman Monty D · Edgewood, NMN9485ZAtp Aircraft 1 LLC · Wilmington, DEN9486ASimonson David C · Iron River, WIN9486BMccoy Robert P · Fairbanks, AKN9486GAndrew Odean T · Willow, AKN9486HStegehuis Richard L · Helenville, WIN9486RAnderson Aerial Spraying Serv Inc · Canby, MNN9486XSchilling Aviation Services LLC · Salina, KSN94872Weber Brian T · Hastings, MNN9487AMccown Bill · Dripping Springs, TXN9487BFord Christian G · Pasco, WAN9487UCallejo Joseph S · Port Saint Lucie, FLN9488ARadke Harlow · Hastings, MNN9488GTap Solutions Inc · San Diego, CAN9488MAero Guard Aviation Insurance LLC · Lincoln, NEN9488UGardner Christopher · Addison, TXN94897Baca Raymundo · El Paso, TXN9489ASmith Paul H · Byron, GAN9489TRegistered aircraftRegistration pendingN9489URodriguez Alonso Jr · Alamo, TXN9489XRegistration Pending · Libby, MTRegistration pendingN9489ZMoody Bible Institute Of Chicago · Spokane, WAN948CPCivil Air Patrol · Maxwell Afb, ALN948RRed Baron LLC · Middletown, DEN948SMScenic Concepts LLC · La Crosse, WI
Back to AD 79-10-14 R1