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.
N4569MEllis Wendell Kirk · Gakona, AKN4573ZMatty Elizabeth · Tucson, AZN4576ZBauman Solomon A · Lyle, WAN457FAHartfiel Joel T · Glenwood, IAN4582ZWriedt Dirk · South Beloit, ILN4584ZCompton Michael · Crabtree, ORN4588ZEta Of Missouri Inc · Lone Jack, MON4590BFulltron Aviation LLC · Springfield, MON4590PWings Over Texas Holdings LLC · Denton, TXN4590ZSpeck Daniel N · Waverly, NYN45915Southern Aircraft Consultancy Inc Trustee · Casper, WYN4591ACollins William A · Tillar, ARN4591ZColt Flying Club LLC · Lebanon, PAN45928Cohan Thomas A · Sparks, NVN45941G&M Aircraft Inc · Wheat Ridge, CON4594ZRichard Waldren LLC · Newberg, ORN4596AMlfco LLC · Wilmington, DEN4596PClements Willie E · Pembroke, GAN4596ZEscue Dean · Milford, NJN4597ZEgan Richard G · Tallahassee, FLN4598QAbanks Leasing Ltd · Wilmington, DEN459ETGerard Luke T · Johnson, KSN45EZThorsen Matthew G · Milwaukee, WIN45FASilver Express Co DBA · Miami, FLN45FCStearns Stephen C · Boulder, CON45HWWimmer Herman J · Feura Bush, NYN45VEBaron John B · Mesa, AZN46020Registration Pending · Brooksville, FLRegistration pendingN46021152 4 Fun LLC · Gilbert, SCN4602ZMoorefield Oscar W · Monroe, GAN46034Employment Services Inc · Virginia Beach, VAN4603ZN4603z Colt Flyers LLC · Kenmore, WAN46075Perspective Aviation LLC · Comer, GAN46080Sentinel Services Group LLC · Brooksville, FLN46090Sentinel Services Group LLC · Brooksville, FLN4609LStork 1 LLC · Green Cove Springs, FLN4610ZGrantham Farley · Bush, LAN4611ZRichard Waldren LLC · Newberg, ORFirst renewal noticeN46134Training Planes LLC · Tampa, FLN46135Mc Masters James I · Springfield, VAN46138Sunrise Aviation Inc · Ormond Beach, FLN46146Skylink Xpress Inc · San Bernardino, CAN4614BUniversity Of Michigan Flyers · Ann Arbor, MIN4616ZBest David Eugene · Newalla, OKN4618PLaguna Verde Leasing Inc · Wilmington, DEN4618ZFilhart Robert · Rosebush, MIN461TCFlorida Flight Training Center Inc · Venice, FLN4621ZGodbold Donald W · Camden, ALN4623ZCordell Ricky L · Fairfield, PAN46249Hyldburg Aviation Inc · Plymouth, MA
Back to AD 80-25-02 R2