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.

N711RNGoldsmith Donald E Jr · Brandywine, MDBuilt 1973 · S/N 17702010N711RPJwp Flying Services LLC · Chatfield, MNS/N 1081N711RVNicholson Kameran · Fowler, KSS/N 290N711SGGullo Santo · Ponce Inlet, FLBuilt 1966 · S/N 30-1300N711SHHighley Robert W Jr · Lakeland, FLBuilt 1984 · S/N 835N711TANorth Star Equipment LLC · Simms, MTBuilt 1958 · S/N 24-481N711TSStarr William E · Eagle River, AKBuilt 1976 · S/N 18-7609046N711UATuthill Andrew M · Etna, NHBuilt 1978 · S/N 17271695N711WBNewberg Edgar T · Hector, MNS/N B-1N711WDSeawind Adventures LLC · Reno, NVBuilt 2004 · S/N 51N711WEMelbourne Flight Training LLC · Melbourne, FLS/N 17272616N711XCFore Shannon Richard · Wasilla, AKBuilt 2016 · S/N CC19-0009N711YAStegmann Scott A · Port Orange, FLBuilt 1995 · S/N 235N711YCIturriria John M · Kuna, IDFirst renewal noticeBuilt 2005 · S/N 0023N711ZHappenstance LLC · Cabot, ARBuilt 1976 · S/N 177RG0959N712Oman Lee · Sequim, WAS/N 399N7120DWeiss James R · Westlake, OHBuilt 1957 · S/N 22-4980N7120EFlightgest Academy LLC · Morrisville, NCBuilt 2021 · S/N 4496471N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820N7120LTschirhart Larry S · San Antonio, TXBuilt 1974 · S/N AA5-0620N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420N7120VOpulent Investments LLC · Mandan, NDBuilt 1974 · S/N 21-0043N7120YRoyal Ryan M · Lincoln, NEBuilt 1963 · S/N 30-139N7121DBohrman Robert C · New Berlin, WIBuilt 1957 · S/N 22-4981N7121PLecren Douglas · Wasilla, AKBuilt 1958 · S/N 18-7121N7121YUhlemeyer William A · Alvin, TXBuilt 1963 · S/N 30-140N7121ZQuality Aviation Inc · Marana, AZS/N 25-2920N7122AContinental Helicopters Inc · Sheffield, TXBuilt 1999 · S/N 2956N7122BCgu Aviation LLC · Naples, FLBuilt 1956 · S/N 22-4340N7122EChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 4496447N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822N7122JCarrizales Chad A · Jacksonville, ARBuilt 1973 · S/N 32-7300032N7122KMacleod Gary G · Valentine, NES/N 18-335N7122RSimmons Heating And Air Conditioning LLC · Summerville, SCBuilt 1966 · S/N 28-21823N7122VProvance Brent L · Granbury, TXBuilt 1974 · S/N 22-0051N7122YSutton Jack M · Jesup, GABuilt 1963 · S/N 30-141N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823N7123PMclenaghan Alvain N · Phoenix, AZBuilt 1961 · S/N 24-2283N7123UMatherly Frank · Greenbrier, TNBuilt 1964 · S/N 2742N7123WHarvick Wayne P II · Kenmore, WABuilt 1962 · S/N 28-920N7124KBlackburn Douglas W · Auke Bay, AKBuilt 1950 · S/N 18-342N7124LTriad Management Group LLC · Papillion, NEBuilt 1974 · S/N AA5-0624N7124PTalley John T · Clifton, TXFirst renewal noticeBuilt 1961 · S/N 24-2284N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424N7124RNewsome Thomas D · Canal Winchester, OHBuilt 1966 · S/N 28-21825N7124UGoss Brendan · Shady Shores, TXS/N 363N7124VHunter Cameron Brooks · Keller, TXBuilt 1974 · S/N 22-0053N7124WTuchols John E · Lockport, NYBuilt 1962 · S/N 28-921N7125DWarrior Creek Adventures LLC · Moultrie, GABuilt 1981 · S/N A7360CN7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825
Back to AD 81-18-04 R2