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.

N757LKNuckolls Douglas W · Lancaster, CABuilt 1979 · S/N R18201245N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629N757MLSchaffer Michael W · New Meadows, IDBuilt 2013 · S/N 556-2013N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851N757MSAngel Aviation Inc · Peoria, AZS/N 15279854N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876N757PKoerner Lukes Gene · Wisconsin Rapids, WIBuilt 1967 · S/N 24-4604N757PDLeavitt Erin G · Lewiston, IDBuilt 1979 · S/N R18201251N757PMKaiser Gavin · Peachtree City, GAS/N 15279896N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902N757PUAvs Aviation LLC · Williamsburg, VABuilt 1979 · S/N R18201253N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923N757QTMoxley Equipment Co Inc · Council Grove, KSBuilt 1979 · S/N R18201258N757RLRudak Phillip Richard · Wethersfield, CTBuilt 1977 · S/N 15279943N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946N757RSRegistered aircraftBuilt 1978 · S/N R18200308N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950N757RVJohnson Scott E · Land O Lakes, FLBuilt 2025 · S/N 75031N757RZCox Derrell L · Pamplico, SCS/N 15279956N757SCHicks Byron · Manchaca, TXBuilt 1977 · S/N 15279959N757SDYu Hermon Lemuel C · Mays Landing, NJBuilt 1977 · S/N 15279960N757SP4e Aviation LLC · Alpine, UTS/N R18201261N757SQByrne Sarah Boltz · Dallas, TXBuilt 1979 · S/N R18201262N757STChester Charter Inc · Chester, CTBuilt 1977 · S/N 15279974N757SWSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1977 · S/N 15279977N757TMontgomerie Robert A · Oriental, NCBuilt 2006 · S/N 1854LN757TAHofmeister Laurence C · Punta Gorda, FLBuilt 1977 · S/N 15279981N757TDNew Horizon Aviation Inc · Warwick, RIBuilt 1977 · S/N 15279984N757THGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 15279988N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991N757TMMayeur Terri-Jo · Wasilla, AKBuilt 1950 · S/N 18-336N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000N757TWHildebrand Russell W · Chandler, AZBuilt 2002 · S/N 23911N757UGehret Barry · Sonoma, CABuilt 1965 · S/N 933
Back to AD 81-18-04 R2