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.

N6970UCampbell Steven D · Henderson, NVBuilt 1964 · S/N 330N6971DVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-5497N6971JMurphy David Charles · Rancho Cucamonga, CABuilt 1976 · S/N 28-7625263N6971QRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1968 · S/N MB-318N6971TTodaro Rodney F · Tullahoma, TNBuilt 2004 · S/N SRE041N6971UStephen Jacoby A · Coconut Creek, FLS/N 331N6971WPop-A-Top Corp · Nashville, MIBuilt 1965 · S/N 28-21169N6972HWoodstock Aviation LLC · Anchorage, KYBuilt 1946 · S/N 20214N6972JBicker Farms Lllp · Tioga, NDBuilt 1976 · S/N 28-7690445N6972KCawley Rebecca L Personal Representative · Lewiston, IDBuilt 1950 · S/N 20-77N6972RWhite Robert Graydon · Damascus, ORBuilt 1976 · S/N MC-323N6972UAyres Floyd Dean · Leavenworth, KSBuilt 1964 · S/N 422N6972WPryce James T · Ebensburg, PABuilt 1965 · S/N 28-21170N6973HScheerer Jill · Sag Harbor, NYBuilt 1975 · S/N 17265673N6973JStracener Adam · Pittsburg, TXBuilt 1976 · S/N 28R-7635369N6973KSmith Scott B · Sterling, AKBuilt 1950 · S/N 20-78N6974BHill Karl D · Igiugig, AKBuilt 1957 · S/N 18-5095N6974HWatsonair LLC · Carlsbad, CABuilt 1975 · S/N 17265674N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116N6974RPaulsen David · Danville, CABuilt 1974 · S/N M-1587N6974VRegistered aircraftBuilt 1976 · S/N 22-1341N6974WRolland Jason J · Plumas Lake, CABuilt 1965 · S/N 28-21172N6975HRoot Shane G · Dighton, KSBuilt 1975 · S/N 17265675N6975QWeber Mark J · Hoven, SDBuilt 1968 · S/N MA-338N6975UBallou-Crawford Terry · Savannah, MOBuilt 1964 · S/N 335N6975VRodmark Aviation LLC · Jupiter, FLBuilt 1976 · S/N 22-1342N6976QBeech 76q LLC · Englewood, FLBuilt 1968 · S/N MA-339N6976UHumble Enterprises Inc · Valley Head, ALBuilt 1964 · S/N 336N6976WHorst Paul N · Lebanon, PAFirst renewal noticeBuilt 1965 · S/N 28-21174N6977QAnderson Gary D · Mechanicsville, MDBuilt 1968 · S/N MB-325N6977RSundowner Aviation Inc · Blaine, MNBuilt 1974 · S/N M-1620N6977UPoss Alexander C · Del Rio, TXBuilt 1964 · S/N 337N6978BVantrease Jerold Lee · Homer, AKS/N 18-5100N6978KMoore Jeffrey D · Blossvale, NYS/N 20-81N6978PGallego Victor · Matawan, NJBuilt 1960 · S/N 24-2121N6978RDodson International Parts Inc · Rantoul, KSS/N MC-324N6978UDouglass Rick C · Bakersfield, CABuilt 1964 · S/N 338N6979DKohlhase Amy M · Anchorage, AKBuilt 1957 · S/N 18-5507N6979HWhitaker Ian S · Fort Mohave, AZBuilt 1975 · S/N 17265678N6979JImani Cameron · Lexington, KYS/N 28-7690446N6979QShlomo Yaron · Honolulu, HIBuilt 1969 · S/N MB-403N6979UGiles Forrest D · Springtown, TXBuilt 1964 · S/N 339N6979WCzygan Noel · Rapid River, MIBuilt 1965 · S/N 28-21177N697CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881133N697CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11562N697FCBlackhawk Holding Corp · Wilmington, DES/N 726-70N697FLAeroflyin Corp · Pembroke Pines, FLS/N 17276100N697FTSilvey Michael Duane · Newhall, CABuilt 1973 · S/N 28R-7335140N697LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881686N697NDSouth Dakota State University · Brookings, SDBuilt 2015 · S/N 4496385
Back to AD 81-18-04 R2