OpenAirDocs.org
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.

N4917LBlankenbaker Myron K · Jacksonville Beach, FLBuilt 1967 · S/N 28-4282N4917ZGibsons Gas Inc · Holland, NYS/N 22-8506N49189Anderson Seth A · Buckeye, AZS/N 15281182N4918CJetblack Ventures LLC · Bakersfield, CABuilt 2005 · S/N 1264N4918FBarnes Charles G · Louisville, KYBuilt 1976 · S/N 28-7715081N4918HMarks Aviation Corp · Beverly Hills, CABuilt 1979 · S/N 15284020N4918JWoolley Charles K · Clarksville, TNBuilt 1968 · S/N 28R-30638N4918LAthene Solutions LLC · Coral Springs, FLBuilt 1967 · S/N 28-4283N4918SSilverado Sales Inc · Orem, UTBuilt 1980 · S/N R18201457N49191Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281184N49192Torii Aviation LLC · Naperville, ILBuilt 1974 · S/N 28-7410025N49194Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281186N49197Wilt Aviation Consulting LLC · Sebastian, FLBuilt 1977 · S/N 15281188N49199Wygant Amanda N · Copper Center, AKBuilt 1977 · S/N 15281189N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102N4919LCroft Jeffrey W · Tennessee Colony, TXBuilt 1967 · S/N 28-4284N4919PRiggs Charles A · Pembroke Pines, FLBuilt 1981 · S/N 15284841N491CMMottinger Casey P · Elizabeth, COBuilt 2012 · S/N 82107N491DKey City Fliers · Maquoketa, IABuilt 1973 · S/N 28-7325632N491EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12259N491ETKennebeck Ronald C · Johnston, IABuilt 1968 · S/N 28-24880N491FLWashington Fliers Inc · Pantego, NCBuilt 1971 · S/N 28-7125304N491GShelton Christopher O · Aubrey, TXBuilt 1968 · S/N 28-25022N491JPGuy Jeffrey · Centerburg, OHS/N 491N491MABelle Casa Sport LLC · Tarpon Springs, FLBuilt 2004 · S/N 957-2004N491NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496236N491PDAir Ventures Awaits LLC · Middletown, DEBuilt 1974 · S/N M-1574N491SFSnohomish Flying Service Inc · Snohomish, WABuilt 2003 · S/N 172S9565N491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARBuilt 1998 · S/N 172S8032N491WSDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 172S8305N49202Skylogix Aircraft LLC · La Verne, CABuilt 1977 · S/N 15281191N49208Graf Eugene · Bozeman, MTS/N 214N4920LLvc Air LLC · Allen, TXBuilt 1967 · S/N 28-4285N4920PDetert Bradley · Valparaiso, INBuilt 1962 · S/N 27-510N4920SExecutive Flyers Inc · Sacramento, CAS/N R18201459N49215Dukelow Thomas W · Bad Axe, MIBuilt 1979 · S/N 15283437N4921JHerdrich Sean D · Manchester, IABuilt 1968 · S/N 28R-30642N4921LBarrett Howard L · Austinville, VABuilt 1967 · S/N 28-4286N4921PAndre David E · San Jose, CABuilt 1962 · S/N 27-511N4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416N49226Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1979 · S/N 15283439N4922BAvcorp Holdings Inc · Jackson, MIBuilt 1979 · S/N 15283706N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469N4922JOpat Randall J · Port Saint Lucie, FLS/N 28R-30643N4922LSpanjer William H · Pine Bush, NYBuilt 1967 · S/N 28-4288N4922SNyrhinen Aki · Reno, NVBuilt 1980 · S/N R18201461N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417N49230US Flight Academy International Inc DBA · Post, TXBuilt 1977 · S/N 15281205
Back to AD 81-18-04 R2