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.
N50636Placer Aviation LLC · Loomis, CAN5063DIndian Ridge Ag Enterprises LLC · Pavillion, WYN5063LVirga Aviation LLC · Virginia Beach, VAN5063WChampagne Patrick D · San Angelo, TXN5063XGrundy James W · West Greenwich, RIN5063YPlane Fun Inc Tr Trustee · Snellville, GAN5064GCurran Joseph R · Eielson Afb, AKN5064KShin Harry K Jr · Castro Valley, CAN5064URowe Timothy R · Texarkana, ARN5064XHuber Bryan L · Jonesboro, ARN5065KHahn Troy J · Troy, OHN5065NWest Valley Flying Club · Palo Alto, CAN5065XWallace Aviation Inc · Wallace, NEN5065ZFour Guys Flying LLC · Tunica, MSN5066GRuggles Arthur E · Andersonville, TNN5066KShiner Mach LLC · Kingwood, TXN5066LMeise Fred W · Moses Lake, WAN5066XChandelle LLC · Chelsea, ALN50678Nieslanik Diane M · Cokeville, WYN5067CMutter William D · Chelan, WAN5067GJones Jerry E · Pocahontas, ARN5067KN5067k LLC · Lenexa, KSN5067XMiller Johnny D · Rhome, TXN5068DGeorge Delmond L · Dewitt, ARN5068GScaled Composites LLC · Mojave, CAN5068KMcclung Matthew T · Avon, INN5068LPark Jalynn C · Blacksville, WVN5068TAbc Leasing Inc · Oakdale, LAN5068UCaywood Beauregard Janice E · Hollis, NHN5068XNobles Ronny · Live Oak, FLN5068YFarnham Aviation Services LLC · Ames, IAN5069FMunns Dana K · Diamondhead, MSN5069GLeverich J E · Pampa, TXN5069TNiesciur Stephen V · Lancaster, NYN5069UGoff Bayou LLC · Shelby, MSN5069XWright Bruce M · Rosharon, TXN5070GSky Fusion II LLC · Atlanta, GAN5070NWilkinson Dane W · Morgan, UTN5070UO'Donnell Paul E · Schuylerville, NYN5070XN566rm LLC · Wilsonville, ORN5071GRowland Dusters LLC · Raymondville, TXN5071KSkyview LLC · De Smet, SDN5074FKerner Frank W · Saint Charles, MON5074XBaker Jim · Hermosa, SDN5075XOpjorden Chris T · Litchfield, MNN5076XPalmer Bryce P · Chugiak, AKN50778Sale Reported · Hernando, FLSale reportedN5077XLussier John A · Greene, RIN5080FBraun Kevin J · Aberdeen, SDN5080XOber John A · Candor, NY
Back to AD 2000-25-02 R1