AD 80-25-07 R1
Registered aircraft · 25,369
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.
N8296EMosbach Rene A · Sandia, TXN8296GKiehl Austin J · Winnett, MTN8297EConaway Scott J · Traverse City, MIN8298EAberdeen Flying Service · Aberdeen, SDN8299ELondon Corbin Airport Board · London, KYN829BAAdaptive Resources Inc · Fort Morgan, CON829BGGipson Robert E · Port Byron, ILN829JBMathis Robert · Sandersville, GAN829LTThompson Timothy G · Kenosha, WIN829PJMidwestern Twang Communications LLC · Evanston, ILN82AGN82ag LLC · Dahlonega, GAN82EPPosav Holdings LLC · Zephyrhills, FLN82ERMidwest Airmotive Inc · Mount Sterling, KYN82HABeller Ronald D · Morehead, KYN82KDKizita Management LLC · Los Altos, CAN82KLMcdaniel Michael Ray · Hampton Cove, ALN82VBSky Designs LLC · Kalamazoo, MIN8302VStrange Beasts LLC · Chicago, ILN8304VHorning Air LLC · Cresbard, SDN8305VBell Anthony J · Avondale, AZN8306VJones Richard E · Cody, WYN8307VFowler Steve · Washington, INN8309VSunde Bradley J · Fergus Falls, MNN830FJVujic Aleksandar · Kensington, MDN830TNPrianti Paul J · Rockaway, NYN8312VPester Mark C · Crookston, MNN8313VMedlin Wayne D · Marshville, NCN8315VReynolds Eric F · Princeton, MNN8316LCorletto Carlos · Bermuda Dunes, CAN8317GEagle Simulator LLC · Lake Oswego, ORN8317LWalker Paul R · Ursa, ILN8317VLynch Gerald C · Collinsville, OKN8318EJust Planes Inc · Hobbs, NMFirst renewal noticeN8318VVetter Brent E · Helena, MTN8319LLaudon Piper C · Anchorage, AKN831AC831ac Aero LLC · Ogden Dunes, INN831HNChambers Jack · Sonoma, CAN831LBWedekemper Steven E · Brighton, MIN831RHHanson Paul D · Evansville, INN831VZMelbourne Flight Training LLC · Melbourne, FLN8320VThurman Randall N · Mcminnville, ORN8322V11 Point Aviation LLC · Alton, MON8323VToczek Keith E · Yankton, SDN8324EGc Aviation Services-1 LLC · Miamisburg, OHN8329VBuck Timothy A · Howland, MEN832DCCase Daniel J · Spokane, WAN8330VJensen Carla J · Pingree, IDN8331LMjl Investment Company Inc · Branchville, NJN8331VAirplane Binnis LLC · Janesville, WIN8333LLedford Daniel R · Granbury, TX
Back to AD 80-25-07 R1