AD 80-25-07 R1
Registered aircraft · 25,370
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-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N5083WJtc Investments LLC · Tyrone, GAN5083XFlytails LLC · Pace, MSFirst renewal noticeN5084RBenham Eric T · Las Vegas, NVN5085BAccelerated Aviation Instruction LLC · Owatonna, MNN5085KMartin Bach Aviation LLC · Cornelius, NCN5085XAzzalin Giorgio · Jacksonville, FLN50864Rasmussen Agribusiness Inc · Antelope, MTN5086ANeeley James L · Temecula, CAN5086EPark David W · Placentia, CAN5086RSafety In Motion Flight Center Inc · Puyallup, WAN5086XJacono Bruce L · Ramona, CAN5087EDern Aviation · Lake Charles, LAN5087JSession Jason E · Higden, ARN5087KAir Capital Aviators Club · Wichita, KSN5087LGreen Airport Development Corp · Kemah, TXN5087SKartchner Stanley J · Tucson, AZN5087XRichardson Ethan Mack · Mount Pleasant, SCN5088KG & M Aircraft Inc · Wheat Ridge, CON5088LRichmor Aviation Inc · Hudson, NYN5088RGlacier Equipment LLC · Wasilla, AKN5088XAmerican Aviation II LLC · Peyton, CON5089C5089c LLC · Fairhope, ALN5089GFlywell Aviation LLC · Bowling Green, KYN5089JWentzel Ron · Steamboat Springs, CON5089PBroburg Gregory William · Minneapolis, MNN5089RHigh Wing Air Services LLC · Merritt Island, FLN5089XYarger Pete A · Hamilton, INN508GLCirone James · Pampa, TXN508TBlackburn D S · Yukon, OKN508TCFisher Travis L · Odessa, TXN50906Aitken & Wilson Aviation LLC · Leesburg, VAN5090EMelbourne Flight Training LLC · Melbourne, FLN5090QTakai Hiroyasu · San Jose, CAN5090XOwen Suzanne L · Eagle Point, ORN5091717 Leasing LLC · Englewood, CON5091EAmerican Asset Leasing LLC · Aurora, ORN5091SLancellotti Peter · Knoxville, TNN5091TBlank Philip J · Pleasanton, CAN5091XMorois Jake D · Green Bay, WIN5092EKaye Russell G · New Fairfield, CTN5092XCurcio Joseph A Jr · Granite Bay, CAN50935Civil Air Patrol Inc · Maxwell Afb, ALN5093EBohmer Carla M · Tulsa, OKN5093KL A M Capital Management LLC · Sheridan, WYN5093QRiya Aviation LLC · Tracy, CAN5093RSkyhawks Inc · Montoursville, PAN50941Labrucherie Peter E · El Centro, CAN50944Munoz Jacqueline T · Huntsville, ALN50947Bend Aircraft Mechanics LLC · Bend, ORN5094LGorge Winds Aviation Inc · Fairview, OR
Back to AD 80-25-07 R1