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.
N10839Eagle Equity Inc · Valparaiso, INN1083VWoltering Myron B · Granite Bay, CAN10843Mathers Steven A · Post Falls, IDN10844Cohan John K · Marina, CAN10846Drewsaero LLC · Nacogdoches, TXN10847Lowe Luz E · Arlington, TXN10848Thomsen Garrett · Waterville, WAN1084FSiktberg Timothy J · Nashville, TNFirst renewal noticeN10856Airplanes And Attitude LLC · Mckinney, TXN10859Aircom Nwa LLC · Siloam Springs, ARN1085MDuncan Terry C Trustee · Cupertino, CAN1086MSargent John E · Vancouver, WAN1086UHancock County Port & Harbor Commission · Kiln, MSN1086VKinney Philip S · Saint Johns, FLN10877Tuskegee Airmen National Historical Museum · Detroit, MIN10880Jackson County Aviation LLC · Sneads, FLN10881M&L Aviation · Woodward, OKN10888Cape Fear Aviation Maintenance LLC · Fayetteville, NCN10889Pilon James G · Lawton, OKN1088UWestern Wyoming Aviation Services LLC · Pinedale, WYN1088VLeiva Lloyd · Bradenton, FLN10891Baker Brandon L · Seeley Lake, MTN10895Aviation Trust Co LLC Trustee · Oklahoma City, OKN10899Angle Of Attack LLC · North Mankato, MNN1089FWells Thomas J · Big Lake, AKN1089MPetersen Clayton · Albert Lea, MNN1089UJkg LLC · Murfreesboro, TNN108ATKirschner John R · Crystal Lake, ILN108CCFlaugher Jonathan S · Poquoson, VAN108EAArellano Erick C · Brownsville, TXN108JMHarris Kenneth L · Greeley, CON108SPDale County Sheriffs Office · Ozark, ALN108SUHardy James · Albany, NYN10903Forty Two J Aviation Inc · Keystone Heights, FLN10906Edens Kenneth L · Hot Springs, ARN1090FIsley Jason T · Sand Springs, OKN1090MBergstrom Aircraft Inc · Pasco, WAN10911Dotson Daniel · Holly Springs, MSN10915Rosling Nathan T · Roggen, CON10918Vondross James B · Portland, ORN1091MSwaz Aviation LLC · Mesa, AZN1091VWeeden Lee R · Lewistown, MTN10921Flying 64th Inc · Oak Ridge, TNN10922Van Horne Robert E · Centralia, ILN10923Dannar Gary D · Muncie, INN10924Anzur Alexandria · Landenberg, PAN10925Schmitz Harold M · Fond Du Lac, WIN10927St Pierre Michael C · Clinton, NCN10929Devils Lake Aero Repair Inc · Devils Lake, NDN10934De Leon Christopher · Donna, TX
Back to AD 2000-06-01