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.

N44413Premier Capital Enterprises LLC · Hurricane, UTBuilt 1974 · S/N 28-7405241N44416Registration Pending · Punta Gorda, FLRegistration pendingBuilt 1974 · S/N 34-7450209N4441JPinkston Lance C · Batesville, ARBuilt 1967 · S/N 28-22846N4441MJohnson Arnold R · Mina, SDBuilt 1947 · S/N 12-3394N4441PMartinson Dominick T · Valdez, AKS/N 5-603N4441RAtwood Flying Club · Atwood, KSBuilt 1974 · S/N 17263184N4441ZThoft Matthew M · Wasilla, AKS/N 18-8785N44420England James M · West Paducah, KYBuilt 1974 · S/N 28-7415635N44421Rojas Alissa · Warwick, RIBuilt 1974 · S/N 28-7415636N44426Skyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842396N44429Bettencourt David A · Dayville, CTBuilt 1974 · S/N 28-7415638N4442AVella La Cava Air LLC · Albuquerque, NMBuilt 1956 · S/N 22-3772N4442XHayes Kevin R · Richmond Hill, GABuilt 1975 · S/N 28-7625034N4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeBuilt 1969 · S/N 18-8786N44430Red Eye Aviation LLC · Minocqua, WIBuilt 1974 · S/N 28-7405242N4443AVollman Merlin · Pearland, TXBuilt 1956 · S/N 22-3773N4443QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842397N4443TKristofzski John · West Richland, WABuilt 1971 · S/N 28-7105228N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044N4443ZMeekin Michael J · Palmer, AKBuilt 1969 · S/N 18-8788N44442Cummins Stephen Michael · Fenton, MOBuilt 1974 · S/N 28-7405244N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001N4444AWesolowski Chris E · Anchorage, AKBuilt 1956 · S/N 22-3774N4444EIllsley Roger J · Santa Rosa, CABuilt 1976 · S/N 28-7690250N4444JMoore James Jeffrey · Midlothian, TXBuilt 2004 · S/N 3788N44450Brown Roy A · Morongo Valley, CABuilt 1974 · S/N 28-7425412N44452Cdr Aviation LLC · Kalispell, MTS/N 28-7425413N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309N4445JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842398N4445KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842399N4445MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-3399N4445PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842400N4445SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842401N4445VSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842402N4445YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842403N4446JScherr Steven · Mandan, NDBuilt 1967 · S/N 28-22850N4446RSiler Jerry L · Eau Claire, WIBuilt 1974 · S/N 17263188N4446ZGrant Kimberly A · Priest River, IDBuilt 1969 · S/N 18-8792N44478Richard J Farmer II · Fremont, OHBuilt 1974 · S/N 28-7405247N4447EFucito Daniel Ross · Lexington Park, MDS/N 38-78A0609N4447MIndiana Aviation Inc · Nicktown, PAS/N 12-3403N4447QWolter Dennis R · Cincinnati, OHBuilt 1973 · S/N 17261719N4447RManos Con Alas Ministries · Sierra Madre, CABuilt 1978 · S/N R18200601N44485Registration Pending · Middletown, OHRegistration pendingS/N 28-7415646N44488Daris James · Fitzwilliam, NHBuilt 1974 · S/N 28-7415647N4448HNorthwest Iowa Flyers LLC · Everly, IABuilt 1978 · S/N 24-0736N4448THoughton John L · Lamar, MOBuilt 1971 · S/N 28-7105227N4448ZGrow Michael J · Palmer, AKBuilt 1969 · S/N 18-8795N44497English William E · Mason City, IABuilt 1974 · S/N 28-7425417N4449CBell Investments LLC · Wasilla, AKS/N 183664
Back to AD 81-18-04 R2