AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01')
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:2000-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01') 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.
N10937Brunet Pedro Angel Rubio · Mulberry, FLN1093VNewman Donald · Hemphill, TXN10940Padden Geary L · Duluth, MNN10941Bunker Seth A · Plymouth, MNN10942Drew Joan N · Maumee, OHN10944Smith Karl D · Columbia City, INN10945Ganton Aviation LLC · Kalamazoo, MIN10946Eastern Flying Service Inc · Middletown, DEN10948Morris Jacky D · Watonga, OKN1094FG&M Aircraft Inc · Wheat Ridge, CON1094UBrajnikoff Edward C · San Francisco, CAN10951Three Stripes LLC · Post Falls, IDN10953Registered aircraftN-number assigned, not yet registeredN10955Westfall Lorn III · League City, TXN10956Flying Toad LLC · Red Oak, TXN1095FEggart Lawrence D · Nome, AKN1095UMalahmeh Adel J · New Iberia, LAN10961Mcphillips Flying Service Inc · Beaver Island, MIN1096UBraten Randall O · Cody, WYN10971Finley James O · Greenville, TXN10975Conover William C · Pittsburg, CAN1097MNunes Lindybergh Jr · Laporte, INN10980Knelson Jan · Lutz, FLN1098MBingham John R · Leawood, KSN1098UKane Patrick · Chicago, ILN10992Totm Holdings LLC · Harbor Springs, MIN10993Bryant Lyle W · Ellinwood, KSN1099FSaal Christopher J · Anchorage, AKFirst renewal noticeN109CFMarigi William Kihara · Worcester, MAN109FRWilson Ronald Earl · Sedona, AZN109RCLentfer Clinton H A · Anchorage, AKN109RSUnited States Department Of Interior · Boise, IDN109SWChugiak Aviation Leasing LLC · Chugiak, AKN109WYPerala Daniel R · Cheyenne, WYN10ARK Airmotive LLC · St Helens, ORN10CRCarlile Aviation LLC · Peculiar, MON10DBBrandon Donald A Trustee · El Monte, CAN10DCHbk LLC · Lynden, WAN10DJNovak Todd · Lumberton, NJN10FLRandall P Roumillat · Dallas, TXN10FPLoves Park Air LLC · Loves Park, ILN10GRamsey Wayne · Abilene, TXN10GLMakulu Adventures LLC · Fort Pierce, FLN10GMAlo Aviation LLC · Titusville, FLN10HGGerardy Harlan D · Gruver, TXN10HLHoyt Robert H Trustee · Canby, ORN10HMAggst LLC · Shingle Springs, CAN10HXIjh Farm Inc · Seminole, TXN10JVHale Thomas O · Cotuit, MAN10KYMckinnon Laughlin Neil Trustee · Carlsbad, CA
Back to AD 2000-06-01