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.
N5203ZWeigel Gary R · Valley City, OHN5204ZGodbey Patrick E T · St Simons Island, GAN5206HMccallum Michael C · Delta, CON5206MAeropaws Aviation LLC · Front Royal, VAN5206ZFord Dustin D · Clear Brook, VAN5208HSweet Richard S · Prior Lake, MNN5208ZArnold Tyler S · Montgomery, LAN5209HCook James F · Portland, ORN5212ZYetter Mark A · Georgetown, PAN5214HVagabond Flight Corporation · Decatur, ILN5215HDavis Ted E · Brodhead, WIN5216HWatkins John W · Somers, CTN5219XBlack Mark A · Lawsonville, NCN5219ZGarrett Joe · Saint Jacob, ILN521QJJacobi John W · Fort Collins, CON5220MCummings Brian · Opelousas, LAN5222HDavidson Gerald W · Okatie, SCN5222ZSaltzman John D · Gilbert, AZN5223HSzorek Evelyn Personal Representative · Fairbanks, AKN5223LN5223l LLC · Cheyenne, WYN5225ZLamon Bruce G · Castle Rock, WAN5226HJockos Sleigh LLC · Fort Worth, TXN5226ZHale Michael E · Grass Valley, CAN52271Horizon Aviation · Seneca, PAN5227HBowman Brent W · Sebewaing, MIN5227ZPayne Robert A · Duluth, MNN5229BPisha Vincent R · Kendall, WIN522EZSkyjiro Forge Corp · Artesia, CANon-citizen corporation, flight hours not reportedN5230HSeneca Aeronautical Services LLC · Wilmington, DEN5231ZKawasaki Clyde H · Carson City, NVN5232ZGilmore Thomas E · Mesa, AZN5233PAero Quest LLC · Olive Branch, MSN5233RVranicar Franklin E · Corona Del Mar, CAN5234XZonneveld Case M · Hanford, CAN5235HMoore Jeffrey D · Cleveland, NYN5235XOrtu Gerard · East Hanover, NJN5236HCarter Flygare Inc · Sacramento, CAN5236ZPlank Larry B · Perkins, OKN5238ZMayer David J · Ingleside, ILN5239BGanim Rose B · Haydenville, MAN5239ZMellor Brad A · Spanish Fork, UTN523EZJackmond Matthew B · Olympia, WAN5240HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5240XPaulson Ricky R · Hudson, WIN5240ZReise Robert A · Meredith, NHN5241PAtwater John G · Vero Beach, FLN5241QWings Over Texas Holdings LLC · Denton, TXN5242HJohnson Steven D · Oklahoma City, OKFirst renewal noticeN5242XMilone Colin B · West Glacier, MTN5242ZLund Thomas S · Boulder, CO
Back to AD 80-25-02 R2