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.

N445ACTholen Susan M · Kennebunk, MEBuilt 1998 · S/N 389-98N445AFPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 17280445N445BDornoch Services LLC · Dover, DEBuilt 2005 · S/N 172S9776N445BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2021 · S/N 4496527N445BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496599N445CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13248N445CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282356N445DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8264N445DHOhio University · Albany, OHBuilt 2005 · S/N 2842233N445KCCramer Kirby · Fallbrook, CABuilt 2004 · S/N 70121N445KSPeraton Services LLC · Bozeman, MTBuilt 2020 · S/N 172S12534N445MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 4496598N445MKNorth Star Aviation · Mankato, MNBuilt 2015 · S/N 4496383N445NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881891N445PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843500N445RDensmore John L · Conway, WABuilt 1974 · S/N 17262596N445RFRichards Jacob · Mount Olive, NCBuilt 2011 · S/N 60385N445SHAgster Air LLC · Granbury, TXBuilt 1991 · S/N 24-3230N445SPGasman401 Aviation LLC · Punta Gorda, FLBuilt 1964 · S/N 481N445WDGurcan Bulent K · Point Roberts, WABuilt 1987 · S/N 445N445WTClayton Edwin G · North Chesterfield, VABuilt 1964 · S/N 2776N445ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881672N44604Lydic Daniel · Pittsburgh, PABuilt 1974 · S/N 28-7425431N44605Luitjens Jacob J · Lagrange, GABuilt 1974 · S/N 28-7415681N4460AHvizdak George D · Colliers, WVS/N 22-3793N4460MScheibe Mark E · Lakeville, OHBuilt 1947 · S/N 12-3412N4460TRuff Randall N · Bay City, MIBuilt 1972 · S/N 28-7225147N4460XStingray LLC · Pensacola, FLBuilt 1975 · S/N 28-7615014N4460YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4109N44614Swair LLC · Denver, COBuilt 1974 · S/N 28-7405265N4461744617 LLC · Post Falls, IDBuilt 1974 · S/N 28-7410100N44618Word Howard W Trustee · Kula, HIBuilt 1974 · S/N 32-7400051N4461AOrtwein Mathew M · Reedsport, ORBuilt 1956 · S/N 22-3794N4461BGaylor Steven C Trustee · Ramona, CABuilt 2009 · S/N 81994N4461HJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 24-0742N4461JBoyd Eric L · Stuart, FLBuilt 1967 · S/N 28-22875N4461MHamm Gregory S · Cordova, AKBuilt 1947 · S/N 12-3414N4461TRobinson Joseph B · Washington, DCBuilt 1972 · S/N 28R-7235058N4461VAimo Joseph Ray · Bountiful, UTS/N 872N4461XHaggerty James D · Scott Depot, WVBuilt 1975 · S/N 28R-7635051N4461YRubbert Jan D · Upham, NDBuilt 1966 · S/N 25-4111N4461ZRed Leasing LLC · Juneau, AKBuilt 1969 · S/N 18-8808N44621Muller-Levan Christina J · Kempton, PABuilt 1974 · S/N 28-7415684N44622Xopena LLC · Kalispell, MTBuilt 1974 · S/N 28-7415685N44624Vensil Pamela J · Frazeysburg, OHS/N 28-7415686N44629M & S Aviation LLC · Lebanon, MOBuilt 1974 · S/N 28-7415687N4462AWeishaar Wallace O · Livingston, TXBuilt 1956 · S/N 22-3795N4462PHighlands Aero Flight Center LLC · Abingdon, VABuilt 1962 · S/N 23-1983N4462RLockwood Ronald D · Filer, IDBuilt 1974 · S/N 17263204N44637Able Construction Inc · Jacksonville, FLBuilt 1974 · S/N 28-7415692
Back to AD 81-18-04 R2