OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-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:2009-10-09-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.

N18057Palmer Jedidiah J · Lewiston, IDS/N 15073763N18061Foster Rodney D · Quanah, TXBuilt 1972 · S/N 15073765N18067Get Out Aviation LLC · Palmer, AKS/N 15073769N18069Olandese Donald J · Newalla, OKBuilt 1972 · S/N 15073771N18071Rock River Aviation · Watertown, WIBuilt 1972 · S/N 15073773N18076Angelos Mark A · Concord, CAS/N 15073776N18081Eyes Above LLC · Hampton Falls, NHBuilt 1972 · S/N 15073780N18088Durin Steven C · Steward, ILS/N 15073784N18100Liberty University School Of Aeronautics · Lynchburg, VABuilt 1972 · S/N 15073785N18104Toth Stephen K · Northampton, PABuilt 1972 · S/N 15073788N18109Szoke Elliott · Mukilteo, WAS/N 15073792N18110Radke Steven H · Hastings, MNBuilt 1972 · S/N 15073793N18115Hinds Community College · Raymond, MSBuilt 1972 · S/N 15073796N18126Harroun Charles G · Maryville, MOBuilt 1972 · S/N 15073804N18140Johnroe Ryan M · Mount Pleasant, MIBuilt 1972 · S/N 15073815N18144Kachemak Bay Flying Service · Temple, TXBuilt 1972 · S/N 15073817N18145Stlouis Aviation LLC · Miramar, FLBuilt 1972 · S/N 15073818N18155Willis Nathan Eric · Broken Arrow, OKBuilt 1972 · S/N 15073828N18157Matz Robert D · Niles, MIBuilt 1972 · S/N 15073830N18162Pruzek Richard L · Chippewa Falls, WIBuilt 1972 · S/N 15073834N18163Wings Aero LLC · Zeeland, MIBuilt 1972 · S/N 15073835N18164Cendejas Agustin · Chino, CABuilt 1972 · S/N 15073836N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838N18171Isaacson Arthur T · Hillsboro, MOS/N 15073840N18173Bb Aero Works Ltd · Whitehouse, OHBuilt 1972 · S/N 15073842N18177Hoffman Rick W · Elk River, MNBuilt 1972 · S/N 15073846N18180Woodward Aviation · Varnville, SCS/N 15073847N18189Jaam-A LLC · Matthews, NCBuilt 1972 · S/N 15073852N18197C150 Holdings LLC · Newark, DEBuilt 1972 · S/N 15073854N18198Ohare Douglas K · Ainsworth, NEBuilt 1972 · S/N 15073855N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856N181VVScriva Jennifer L · Sherwood, ARBuilt 1966 · S/N 15065010N18200Morristown Flying Service Inc · Talbott, TNBuilt 1972 · S/N 15073857N18201Anderson William T · Pine Bluff, ARBuilt 1972 · S/N 15073858N18202Flying Tomato Aviation LLC · Medina, OHBuilt 1972 · S/N 15073859N18208Ivy James E · Alba, TXS/N 15073863N18210Aircraft Construction Specialist Inc · Collinsville, OKBuilt 1972 · S/N 15073865N18213Diek Mondo R · Stevenson, WABuilt 1972 · S/N 15073867N18222Baxter Paul A · Logandale, NVBuilt 1972 · S/N 15073876N18225Cosentino Allen P · Templeton, MABuilt 1972 · S/N 15073878N18229Fluno John I · San Anselmo, CABuilt 1972 · S/N 15073882N18233Geiger Kurtis · Visalia, CABuilt 1972 · S/N 15073886N18234Nance David B · Quinton, VABuilt 1972 · S/N 15073887N183ERMustang Sally Aviation LLC · Camden, SCBuilt 1972 · S/N 15073584N18501Dunbar Stephen E Trustee · Broken Arrow, OKS/N 15073894N18502Smith Stewart K · Samson, ALBuilt 1972 · S/N 15073895N18503Asejo Emmanuel · Kaaawa, HIBuilt 1972 · S/N 15073896N18505Webb Terrell W · Albemarle, NCBuilt 1972 · S/N 15073897N18506Mc Carley Kendel · Tucson, AZBuilt 1972 · S/N 15073898N18519Chrystall Shane · Marysville, OHBuilt 1972 · S/N 15073909
Back to AD 2009-10-09 R2