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.

N192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILBuilt 1985 · S/N 15285979N192PMScheib Michael A · Dauphin, PABuilt 1967 · S/N 15067467N19302Halverson Mark S · Mason City, IABuilt 1973 · S/N 15074319N19303Saini Vijay S · Saint Petersburg, FLBuilt 1973 · S/N 15074320N19305Surface To Air Corp · Wilmington, DEBuilt 1973 · S/N 15074322N19306Barr Shane G · Wexford, PABuilt 1973 · S/N 15074323N19312Morley Thomas O · Riverside, CABuilt 1973 · S/N 15074329N19313Stout Walt · Willow Beach, AZBuilt 1973 · S/N 15074330N19315Adams Jacob M · Port Orchard, WAS/N 15074331N19320Hynes Timothy M · Pepperell, MABuilt 1973 · S/N 15074335N19323Novinski Gerald W · Jacksonville, FLBuilt 1973 · S/N 15074338N19325Leon River Aerial Services LLC · Dublin, TXBuilt 1973 · S/N 15074339N19326Sagen Josh H · Kalispell, MTBuilt 1973 · S/N 15074340N19328Amesbury Robert S · Davis, CABuilt 1973 · S/N 15074342N19329Harvey James · Arlington, TNBuilt 1973 · S/N 15074343N19333Northwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 15074346N19334Beiswinger Matthew · Republic, MOBuilt 1973 · S/N 15074347N19336Ozark Aviation Services LLC · Wasola, MOBuilt 1973 · S/N 15074349N19342Wojciechowski Calvin · Sonoma, CABuilt 1973 · S/N 15074352N19343Goheen Gordon C · Battle Ground, WABuilt 1973 · S/N 15074353N19345Dynan Erik J · Whitefield, NHBuilt 1973 · S/N 15074355N19346Acevedo Adriel · San Antonio, TXBuilt 1973 · S/N 15074356N19351Place Joseph E · Springville, NYBuilt 1973 · S/N 15074359N19355Airco Interational LLC · Arlington, WABuilt 1973 · S/N 15074360N19358Browning Helen · Peoria, ILBuilt 1973 · S/N 15074362N19364Ja Flight Services LLC · Sugar Grove, ILBuilt 1973 · S/N 15074366N19367Boyer Timothy J · York, PAS/N 15074369N19374Wilson Aviation Consulting LLC · Willis, TXS/N 15074374N19377Caffroy Daniel R · Anchorage, AKBuilt 1973 · S/N 15074376N19380Fannin William A II · Lexington, KYS/N 15074378N19384Armstrong Thomas J · Ann Arbor, MIBuilt 1973 · S/N 15074381N19388Kittner Robert T · Ellenville, NYBuilt 1973 · S/N 15074383N19389Clenow Mark · Brighton, MABuilt 1973 · S/N 15074384N19400Bailis David P · Bethlehem, PAS/N 15074395N19404Borden Kim L · Fair Haven, NYBuilt 1973 · S/N 15074399N19406Clark Caroline Ray · Anderson, SCS/N 15074401N19409Owen James A · Jud, NDBuilt 1973 · S/N 15074404N19410Sather Evan A · Hayward, CABuilt 1973 · S/N 15074405N19413Ahlgren Jon E · Juneau, AKBuilt 1973 · S/N 15074406N19414Bailey Brian D · Bethesda, MDFirst renewal noticeBuilt 1973 · S/N 15074407N19422Bellefontaine Georges E · Shady Shores, TXBuilt 1973 · S/N 15074413N19439Technical Education Services Inc · Virginia Beach, VABuilt 1973 · S/N 15074419N19451Allison Jeremy L · Chandler, AZBuilt 1973 · S/N 15074427N19453Top Flight LLC · Wilmington, DES/N 15074429N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433N19476Havron Dana Houston · Huntsville, ALS/N 15074438N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442
Back to AD 2009-10-09 R2