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.
N5055ZStevens Mark F · Ocean Springs, MSN5056TGator Flight LLC · Saint Cloud, FLN5058KWinemiller Stevie D · Swifton, ARN5058NCarbone Cabana Boys LLC · Mercer Island, WAN5059GLumland Properties LLC · Winchester, VAN5059NSchultze Joseph Dale · Mound, MNN5059ZWarren Kenneth N · Anamosa, IAN505SHHitchens Steven L · Newark, OHN5060NNarveson Bryce J · Nerstrand, MNN5060XFour Guys Flying LLC · Tunica, MSN5062GMore Right Rudder LLC · Menlo Park, CAN5062JDomack Christopher S · Toccoa, GAN5062ZTerpstra Gregory K Trustee · Potosi, MON5063ZMuehlberg Timothy M · Tuttle, OKN5064KShin Harry K Jr · Castro Valley, CAN5064ZGregory Trace D · Springfield, MON5065KHahn Troy J · Troy, OHN5065NWest Valley Flying Club · Palo Alto, CAN5066GRuggles Arthur E · Andersonville, TNN50674Garcia Joan M · Orlando, FLN5067CMutter William D · Chelan, WAN5068KMcclung Matthew T · Avon, INN5068UCaywood Beauregard Janice E · Hollis, NHN5068YFarnham Aviation Services LLC · Ames, IAN5069FMunns Dana K · Diamondhead, MSN506DKolstad David L · Northridge, CAN506DEAero Fliers LLC · Kalispell, MTN5070ZMoser Gary A · Van Wert, OHN5072ZMunning Doris E Trustee · Sellersburg, INN5075XOpjorden Chris T · Litchfield, MNN5076ZBottoms Michael L · Danbury, NCN5078ZPierce Justin P · Conifer, CON5079ZJohnson Sappa Farms LLC · Stamford, NEN5080ZBrazil Joshua B · Omaha, NEN5081ZTech Mobile LLC · New Windsor, MDN5082ZHuddleston Anthony A · Knoxville, TNN5083ZMorell Patrick J · Byron Center, MIN5085BAccelerated Aviation Instruction LLC · Owatonna, MNN5086ZRichards Curtis A · Troy, MON5087LGreen Airport Development Corp · Kemah, TXN5088LRichmor Aviation Inc · Hudson, NYN5088XAmerican Aviation II LLC · Peyton, CON5088ZDavis Scott A · Bingham, NEN5089PBroburg Gregory William · Minneapolis, MNN5089XYarger Pete A · Hamilton, INN508TBlackburn D S · Yukon, OKN5090QTakai Hiroyasu · San Jose, CAN5090XOwen Suzanne L · Eagle Point, ORN5091XMorois Jake D · Green Bay, WIN5092XCurcio Joseph A Jr · Granite Bay, CA
Back to AD 80-25-02 R2