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.

N56086Cacolici Dominic · Saint Petersburg, FLBuilt 1973 · S/N 28R-7335349N5608USchoenberger Amber J · Niceville, FLS/N 28-26537N5608ZSale Reported · Casper, WYSale reportedBuilt 1962 · S/N 22-9420N56090Wood William J · Jackson, GABuilt 1973 · S/N 28-7325570N56098Wong Yi C · Aurora, COBuilt 1973 · S/N 28-7325571N5609LTaylor Darius · Fayetteville, GABuilt 1972 · S/N AA5-0209N5609USteves Landavator Service LLC · Oley, PAS/N 28-26539N5609ZRowland Gary W · Edmond, OKBuilt 1962 · S/N 22-9421N560APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843763N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947N560BYShogbonyo Michael A · Arlington, TXBuilt 1973 · S/N 28R-7335333N560CPStory Charles M · Leesburg, FLBuilt 2002 · S/N 369N560DKN560dk LLC · Newark, DEBuilt 2023 · S/N 254N560EHSafeflightops LLC · Venetia, PAS/N 10589N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560N560FLBancroft Robert W · Aurora, NYBuilt 1975 · S/N 28-7625026N560MWRegistered aircraftBuilt 2011 · S/N 72633N560PCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281915N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098N560RJJenaero LLC · Cincinnati, OHBuilt 1993 · S/N 7637N560TCCacek Thomas E · Crescent City, FLBuilt 1995 · S/N TC2N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668N560ZHeslin Jon P · Sutton, MABuilt 1974 · S/N 17262889N56101Seniram Air Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335354N56105Anderson Wendell R · Brainerd, MNBuilt 1973 · S/N 28-7325573N5610HReese Christopher R · Hanover, MNBuilt 1949 · S/N 16-217N5610QRustad Scott K · Minot, NDBuilt 1965 · S/N 709N5610UAnderson Aviation LLC · Bulverde, TXBuilt 1969 · S/N 28-26540N5610ZMcvey James W · Mentor, OHBuilt 1962 · S/N 22-9422N56114Anderson Douglas · Queen Creek, AZS/N 28R-7335357N56115Schenck Christopher R · The Woodlands, TXBuilt 1973 · S/N 28R-7335358N56119Button Eric T · Austin, TXBuilt 1973 · S/N 28-7305532N5611PWeyland Aviation Inc · Lewes, DEBuilt 1959 · S/N 24-679N5611QSale Reported · Star Prairie, WISale reportedBuilt 1965 · S/N 3004N56125Upstate Flying Club Inc · Marcy, NYBuilt 1973 · S/N 28-7305535N56126Moore Holdings LLC · Janesville, WIBuilt 1973 · S/N 28-7305536N56129Skurzynski James S · Santa Ana, CABuilt 1973 · S/N 28R-7335361N5612LHolden Jason K · Conroe, TXBuilt 1968 · S/N AA1-0014N5612PClarity Aviation LLC · Boise, IDBuilt 1959 · S/N 24-680N5612QSrm Aviation Group LLC · Bentonville, ARBuilt 1965 · S/N 662N56130Flying Aces Aero-Fleet Inc · Guyton, GABuilt 1973 · S/N 28R-7335362N56131Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 32-7300052N56134Buxton Richard L · Boise, IDBuilt 1973 · S/N 28-7325578N56136Weed Brian Jeffrey · Omaha, NEBuilt 1973 · S/N 28-7305538N5613LRed Rock Flyers LLC · Flagstaff, AZBuilt 1974 · S/N 0704N5613QLysek Eric M · Erie, COBuilt 1965 · S/N 3005N5613UAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1970 · S/N 28-26543N5613WHocking Terry G · Nashwauk, MNBuilt 1962 · S/N 28-753N5613ZAndersen Zachary J · Seward, AKBuilt 1962 · S/N 22-9424N56140Lets Fly Az LLC · Scottsdale, AZBuilt 1973 · S/N 28-7305539
Back to AD 81-18-04 R2