AD 2000-25-02 R1
Registered aircraft · 7,563
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-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N85337Port Townsend Aero Museum · Port Townsend, WAN85338Minor J Mark · Rockledge, FLN85339Aviators Of Texas LLC · Georgetown, TXN85343Greene Antony B · North Fort Myers, FLN85344Krog Donald C · Somerville, NJN85348Passeno Mark A · Cheboygan, MIN85349Paine Oliverb III · Fulton, NYN8534ETyler Ronald A Jr · Valrico, FLN85353Linstad Daniel E · Canby, ORN85362Demmers Jesse T · Jordan, MNN85364Roberts Raymond W · Smithfield, RIN85366Lemieux Kenneth G · Oneida, TNN85367Stewart Richard S Jr · North Liberty, INN8536EKaminski Daniel · Monee, ILN8537Kopaska Linda · Guthrie Center, IAN85371Williams Darrell W · Fayetteville, ARN85375Ropp Dorothy E · Poplar Grove, ILN85378Benger Jeffrey S · Bozeman, MTN8537EHoech Neal L · Sandpoint, IDN85380Holmgren Michael G · Kulm, NDN85381Kieffer Michael · Honey Creek, IAN85383Faulkner Ronnie L · Mount Ida, ARN85384Stenger Douglas E · Banks, ORFirst renewal noticeN85387Temple Peter L · Harrisville, NHN8538EAgaliotis Paul E · San Martin, CAN85393Crooks Sean P · Canton, MIN85394Cunningham Blake F · Rockville, INN85396Patton Steven R · Wayne, OHN85397Kyle E Rich Inc · Sumner, IAN85398Gann Gerald N · Conway, MON8539EWombles Michael · Greenwood, INN85400Champ85400 LLC · West Jordan, UTN85401Bartee Chaddick M · Lubbock, TXN85403Fossa Joseph · Essex, MAN85406Crum John P · Waterloo, ILN85411Debaun Gary · Terre Haute, INN85413Becker William A · Burlington, WIN85420Registered aircraftN85421Tillery Bernard Ray · Perris, CAN85424Dirks Daniel P · Seguin, TXN85425Micro Aerodynamics Inc · Anacortes, WAN8542ESchillo Paul J · Wrenshall, MNN85430Weitemier Jeffrey D · Browerville, MNN85433Sturgell James A · Blanchard, OKN85434Letourneau Robert J · Plympton, MAN85439Kupka John J · Fremont, OHN85440Catt Kevin R · Salinas, CAN85442Hayton James B · Sedro Woolley, WAN85448Poklar Norman A · Mount Orab, OHN85450Barnes Rodney E · Oconomowoc, WI
Back to AD 2000-25-02 R1