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.
N5361HNall Melvin J · Luthersville, GAN5364POwens Flight Training LLC · Lafayette, LAN5364ZHughes Tony W · Irmo, SCN5365HVyfvinkel Frederick J · New Smyrna Beach, FLN5366HShannon Harry D · Bartow, FLN5366MHillsboro Aero Academy LLC · Hillsboro, ORN5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedN5368MPacific Union College · Angwin, CAN5368ZTevik Michael A · Provo, UTN5369HValdiosera Octavio · Tracy, CAN536CBZelner Gregory · Merritt Island, FLN5370HGodec David E · Waunakee, WIN5371HMacdonald Randall N · Weidman, MIN53740Gardner Robert J · Orwigsburg, PAN53745Speth Kerry G · Oak Harbor, WAN5374ZMyers Kenneth Jerome · Haines, ORN53764Push To Talk Aviation LLC · Burr Ridge, ILN53769Holcomb Garry · Greenville, TXN53773Brock Edwin G · Hawthorne, FLN5377HSchmid Gerhard G · New Smyrna Beach, FLN5377ZTurner Edward J III · Mokena, ILN53781Hayden Aviation LLC · Rhome, TXN5378BDraper Floyd L · El Paso, TXN5379ZMcelwee Glenda A · Lake City, FLN537NMasure Jason F · St Helena Is, SCN53801Stegman Edward L · Oceanside, CAN53804Bell Cody R · North Pole, AKN5380HBaughman Neil F · Harrisburg, PAN5380ZHerrema James M · Fountain, MIN5381ZRasmussen Mark · Hogeland, MTN53823Ferguson Carrie L · Palo Alto, CAN5382HZefting Brett M · Bellingham, WAN53832Kalis Dakota E · Blue Earth, MNN53836Tailwheel Solutions LLC · Chagrin Falls, OHN5383MSunrise Aviation Inc · Ormond Beach, FLN53847Driftless Aviation LLC · Burlington, WIN5384HDeleon Joseph M · Saint Petersburg, FLN5384PKs Aviation Inc · Atwater, CAN53852Cohran Enterprise LLC · Pineville, LAN53855Messmore Michael H · Toledo, WAN5386HMcwhorter Ag LLC · Searcy, ARN5386ZKetcham Blake L · Turtle Creek, PAN53871Walker Benjamin L · Muscle Shoals, ALN53872May Chris H · Owensboro, KYN53874Sloan Donald W · Dover, DEN5387BHuffman Jacob M III · Burleson, TXN5387CGoral William W · Redlands, CAN5387ZHester Nathan A · El Centro, CAN53887Lawson Bradley K · Plymouth, MIN5388HRamsey Brian D · Van Nuys, CA
Back to AD 80-25-02 R2