AD 2000-25-02 R1
Registered aircraft · 7,560
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.
N2121EBage Air LLC · Boulder, CON2122EAnkrom Dennis M · Williamson, NYN2125EBrillaud Richard J · Nesconset, NYN21262Aysta Nathan P · Hermantown, MNN2126EBrown Courd · Warr Acres, OKN2127CRowsey Andrew M · Corinth, MSN2130EMarshman Robert M · Murfreesboro, TNN2132EMann Thomas A · Ford, WAN2133ERowan Thomas W · Sterling, AKN213AMNorton Cole R · Marion, IAN213CRJuarez Justin · Garden City, IDN2141ERobertson Mark A Trustee · Keosauqua, IAN2142ECadotte Anthony J · Minnetonka, MNN2143CPlane Fun Inc Tr Trustee · Snellville, GAN2144EWatry Gary J · Malone, WIN2145EKrall Jeff P · Mitchell, SDN2146EBallow Gregg R · West Wareham, MAN2147EJ&Ks Spruce Specimens LLC · Alexandria, MNN214ACRicard Carter J · Albany, MNN214BWKansas Farm & Ranch Inc · Seneca, KSN214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYN214EFMaupin Dean C · Davenport, IAN214LHRocky Mountain Flight Consultants LLC · Boulder, CON2153ERespecki Daniel R · Vassar, MIN215BCMetzler Alan J · Reedsville, PAN215RVJet & Rotor Aviation LLC · Sacramento, CAN2162EMiddletown LLC · Chandler, AZN2163EParrish Brian K · Southlake, TXN216ACLetourneau University · Longview, TXN216BCBell Wendell D · Littlerock, WAN2171EShelton Jeffrey A · Columbus, INN2172EAdams George · Franklin, INN2177ESean P Mcgrath · Plano, TXN2178EHarrell M Clyde Jr · Bainbridge, GAN2179EWeyer Sharon M · Edgewater, FLN217PFBixenman Kenneth J · Colby, KSN2182EGustas David P · Lancaster, NYN2185JSt Clair Donald Lee Jr · Orangevale, CAN2189EJones Duane R · New Carlisle, OHN2192EBeihoffer Daniel J · Tower, MNN2193EGrey Ben · Hyde Park, NYN21FTNordhaus Ronald R · Ottawa, OHN21GCUer LLC · Searcy, ARN21PZEarl'S Spray Service Inc · Breckenridge, MIN2205EWager Douglas K · Mobridge, SDN220JKHiggins Bradley J · Yerington, NVN220MLSaegaert Daniel G · Locust Grove, GAN2212EFletcher Stephen J · Labelle, FLN2215EN7396w LLC · Coeymans Hollow, NYN2216EHicks James R · San Antonio, TX
Back to AD 2000-25-02 R1