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.
N5130TInfinity Aviation LLC · Piedmont, SDN5131XWilson Brent S Trustee · Dyer, NVN5132XLinch Travis R · Belle Fourche, SDN5133TRanspot Richard P · Burlington, TXN5134TLawrence David Denton · Roanoke, VAN5135TRayl Benjamin E · Mason City, IAN5138XKoprek Kevin A · Montrose, CON5139TRatliff John B · Oroville, CAN5139XGlatthaar Richard J · Burbank, WAN5143XHardin John W · Fort Myers, FLN5144TAir Trac Inc · Pasco, WAN5145XAnderson Aviation LLC · Hillsboro, NDN5146BOneal Daniel E · Madison, FLN5146TMattson Randall · Richvale, CAN5146XChart-Airs LLC · West Terre Haute, INN5147XBrown Russell J · Mahtomedi, MNN5148TKloss Matthew Joseph · Rew, PAN5149XAmboni Sinesio Jr · Wasilla, AKN514FVenohr Robert E · Aurora, CON5151XBazer Thomas E · Petersburg, AKN5153TChampion Phyllis W · Reno, NVN5154XTevlin Neal L · Valley, WAN5155TWilkes Marcus W · Simmesport, LAFirst renewal noticeN5155XMassey Karl E L · Monterey, CAN5156XHorton Kelly · Hollis, OKN5158XSchnell Troy A · Alliance, NEN5159TSvggp LLC · Carnation, WAN515CBWard Eddie D · Livingston, TXN515KGBatsche George M · Tampa, FLN515PGHunter Gregory · La Jolla, CAN515SED & H Equities LLC · Helena, MTN5160XCulver Deborah M · Anchorage, AKN5161TStuart M Davis Inc · Rice, WAN5161XSlease Brian D · North Pole, AKN5162TAdvanced Insulation Enterprises LLC · Calhoun, LAN5162XMcmorries Kyle Patrick · Nacogdoches, TXN5163THendrickson Duane J · Rocklake, NDN5164TLeonard Bruce Danield · Spokane, WAN5166XRegistered aircraftN5168TVrooman Lawrence M · Winterville, NCN5168XCulver Marc D · Anchorage, AKN5169XRegistration Pending · Palmer, AKRegistration pendingN516AC39 Victor Aviation Inc · Macomb, ILN5170THardison Aviation LLC · Hampton, SCN5170XFitzpatrick Robert M · Fredericksburg, TXN5171TGowins Steven M · Eagle, AKN5172TJacksonville Aviation Group LLC · Jacksonville, FLN5172XO'Daniel Mike · Elkhorn, NEN5173TMorris Dennie R · North Fort Myers, FLN5173XInabnit Michael S · Colville, WA
Back to AD 2000-25-02 R1