AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N50774White T William · Londonderry, NHN50777Morlan Scott A · Indianola, IAN50778Sale Reported · Hernando, FLSale reportedN5077APut Willem Albert · Birmingham, ALN50781Beard Michael E · Udall, KSN5078ASmith Sidney R · Rllng Hls Est, CAN5078HSorley Dan C · Union, WAN50790Taylor Terry D · Orange Park, FLN50793Matter In Motion Inc · Fox River Grove, ILN50799Jungren Brett F · Elmwood, NEN507AKLohrey Timothy R · Brookville, INN50805Dale Aero LLC · Eloy, AZN5080ACoughlan Sally G · Bigfork, MTN50813Record John W · Apison, TNN50816Dingee Robert G · Clarks Summit, PAN50818Bradley Hayden Ace · Litchfield Park, AZN50819Registered aircraftN5081AJones William H Trustee · Wenden, AZN5081HThomas Douten D · Roxbury, MEN5082AYoung Ryan E · Willis, TXN5082HIan Lussier Inc · Owls Head, MEN50832Whalen John F Jr · West Ossipee, NHN50834Riggin Flight Service Inc · Madison, SDN50835Henson Chad Cox · Galivants Ferry, SCN50836Leeper Miles F · Douglass, KSN50837N50837 LLC · Kaneohe, HIN5083HOlson Mark J · North Pole, AKN50840Dahlgren John W · Little Egg Harbor, NJN50844Ellenson Conroy N · Browns Valley, CAN50846Jackson Bob · Bay City, TXN5084AOsterberg Douglas L · Neenah, WIN5084HHrabe Daren L · Chamberlain, SDN50850Knutson Wayne R · Tioga, NDN5085HWeyland Hendrik J · Udall, KSN50865Smith Leslie A · Waresboro, GAFirst renewal noticeN50868Krekacs Gabor · La Crescenta, CAN50871Saint Joseph Of Cupertino Shenandoah Flying Assoc · Winchester, VAN50874Priddle Linda Ann · Carlsborg, WAN50875Krs Aerial Inc · Plain City, OHN50876Parker David A · Sacramento, CAN5087AMenard Bernny · Abbeville, LAN50887Stanton Sport Aviation Inc · Stanton, MNN5088APieper Mike D · Chandler, OKN5088HSharp Frank J III · Windermere, FLN5089Gifford David M · Las Vegas, NVN50891Peterson Andrew B · Louisville, KYN50896Bankhead David B · Montrose, WVN50898Costa Air Service LLC · Painted Post, NYN5089ABagley James R · Twentynine Palms, CAN508CRZimmerman John H · Tavares, FL
Back to AD 94-05-05 R1