AD 80-25-02 R2
Registered aircraft · 6,349
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:80-25-02-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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.
N761YEUnique Educational Experiences Inc · Signal Hill, CAN7620HMckinney Leonard F · Anchorage, AKN7622HEngler Eric M · Cass City, MIN7625HCook Susan R · Carl Junction, MON7627SJohnson Richard M · Osceola, WIN762AFLake Area Technical Institute · Watertown, SDN762JSSayers James B · Edison, OHN7631HSeibold Bryan S · Big Lake, AKN7632HAndersen Dana K · Scappoose, ORN7633SSageeyah Citabria LLC · Claremore, OKN7634HHudgin James P · Murfreesboro, TNN7635HObrien Kenneth J · Lafayette, CON7636SPrt Aviation LLC · Port Orange, FLN763AFTuskegee Airmen National Historical Museum Inc · Detroit, MIN763SASunrise Aviation Inc · Ormond Beach, FLN76405Koch Carson B · Vancouver, WAN76428Spivey Kenneth R Jr · Vestavia, ALN7643HHartley George V · Anchorage, AKN7644HBunn Jesse R · Wasilla, AKN7645HJohnson Michaela Renee · Anchorage, AKN7646HHudson James W · Wasilla, AKN7648HBranam James G · Middletown, OHN7649HRinebold Jason R · Lewiston, IDN764AFVandenberg Garry F · Grand Haven, MIN764APSale Reported · Kaplan, LASale reportedN764HLKirby Dennis T · Sandia Park, NMN7654HAnderson Ayden M · Twin Bridges, MTN7655HKemper Joseph · Coxs Mills, WVN7656HStephani Timothy M · White Lake, WIN765AFTuskegee Airmen National Historical Museum · Detroit, MIN7661HVan Wagner Aerial Media LLC · Hollywood, FLN7663HZweifel Douglas L · Anchorage, AKFirst renewal noticeN76695Keyte Clinton W · Colfax, CAN7670HRobinson Eric C · Palmer, AKN7671DMartin James P · Sioux City, IAN7671HAir Dakota Flite Inc · Hettinger, NDN7675SKemp Gilbert A · Waterville, NYN76786Engeman Nathon G · Bend, ORN7678HGoth Tedd Lloyd · Hereford, AZN7682HHumphrey Ronald D · Pace, FLN7684HWellborn Ralph L · Kenai, AKN76901Dawsonfens 140 LLC · Pearland, TXN7690HSandstrom Brandon M · Palmer, AKN7691HSanders Wes E · Palos Park, ILN76924Donald Ben B · Carthage, TXN7697HMashburn Daniel T Jr · Bolton, MSN769NERegistration Pending · Pottstown, PARegistration pendingN76CMRegistration Pending · New Braunfels, TXRegistration pendingN76HBSinger Michael · Mission Viejo, CAN76LNHillsboro Aero Academy LLC · Hillsboro, OR
Back to AD 80-25-02 R2