AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.
N7641KEwert Gary P · Worthington, MNN7641RDossey Kevin L · Oroville, CAN76428Spivey Kenneth R Jr · Vestavia, ALN7642GAir Petunia · Claremont, CAN7642JUniversal Technical Institute Inc · Coppell, TXN7642PCollins Daniel R · Klamath Falls, ORN7643CRials Tommy G · Crystal Springs, MSN7643DDowling Matthew H · Clarksville, VAN7643FMaple43f LLC · Hubbardston, MAN7643GTriad Aviation Academy LLC · Greensboro, NCN7643HHartley George V · Anchorage, AKN7643WBlasen Matthew C · La Center, WAN7644DBeale David K · Tullahoma, TNN7644FBel Holdings LLC · Albert Lea, MNN7644GSkypark Inc · Wadsworth, OHN7644HBunn Jesse R · Wasilla, AKN7644KKlauber Robert A · Athens, TNN7644PWhobrey Andrew · Bee Spring, KYN7644WCatania Robert S · Mooresville, INN7645FSagittarius Fox Aviation LLC · San Francisco, CAN7645HJohnson Michaela Renee · Anchorage, AKN7645JArrow 8 LLC · Chicago, ILN7645VBig Sky Aviation Leasing LLC · Helena, MTN7645WGold Rush Air LLC · Anchorage, AKN7645YN7645y LLC · Sheridan, WYN7646DBaier Warren R · Horicon, WIN7646FShouling & Philip Enterprise · Lancaster, CAN7646GSky Aviation LLC · Encinitas, CAN7646HHudson James W · Wasilla, AKN7646JRavotti Air LLC · Leechburg, PAN7646PWebster Michael Sean · Hubert, NCN7647GIowa Lakes Community College · Estherville, IAN7647KLee Andrew · Anchorage, AKN7647PEhni Scott Michael · Trinity, TXN7647WBeaulaurier Robert N · Walla Walla, WAN7648HBranam James G · Middletown, OHN7648RJohnson Jerome L · Victorville, CAN7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYN7649HRinebold Jason R · Lewiston, IDN7649KHaldeman Enterprises LLC · Vancouver, WAN7649PBurton David P · Harviell, MON7649WPatterson Cameron L · Stafford, VAN764AAWings Over Texas Holdings LLC · Denton, TXN764AFVandenberg Garry F · Grand Haven, MIN764APSale Reported · Kaplan, LASale reportedN764BKFairmont State University · Fairmont, WVN764CCYale Companies LLC DBA Hot Wings Aviation LLC · Fishers, INN764DPPerkins David A · Locust Grove, OKN764DRBucket List Aviation LLC · Omaha, NEN764HLKirby Dennis T · Sandia Park, NM
Back to AD 81-18-04 R2