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.

N57SPNuzzo Christian · Starkville, MSBuilt 1975 · S/N 2051N57TPSheradin Daniel R · Roxboro, NCBuilt 2022 · S/N 001N57TVPitts Holdings LLC · Jacksonville, FLBuilt 1982 · S/N 2263N57UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12089N57VBKlingebiel Kurt · Leonardtown, MDBuilt 1985 · S/N 17276476N57VHMiller David · Independence, MOBuilt 1979 · S/N 700N57WTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N 1056N57WCLong Dennis L · Blackshear, GABuilt 1977 · S/N 1N57WDDarling William H · Sprakers, NYBuilt 1966 · S/N 28-3395N57WHMoon Richard B · Arizona City, AZBuilt 1976 · S/N 17267069N57WS4031 Aviation Inc · Bemidji, MNS/N 18-5463N57WYDougherty Dan H · Woodland, CABuilt 2011 · S/N 3127N57YSDavis Jeffery S · Oregon City, ORBuilt 1998 · S/N GA-0063N580Aeroblayze Aviation LLC · Norman, OKBuilt 1972 · S/N 43-72N5800Hayes Dennis P · Des Moines, IABuilt 2005 · S/N 233N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5801HRodriguez Nicholas · Titusville, FLBuilt 1949 · S/N 16-417N5802LHarrold Michael C · Hamilton, MTBuilt 1971 · S/N AA5-0002N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5803EIrwin Donald L · Emporia, KSBuilt 1978 · S/N 17271938N5803PLaskey Steven W · Littleton, COBuilt 1959 · S/N 24-883N5803WClifford William M · North East, MDBuilt 1964 · S/N 28-1877N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134N5804LAa Horizons LLC · League City, TXBuilt 1971 · S/N AA5-0004N5804NAvioneta LLC · Atwater, OHBuilt 1978 · S/N 14372N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5804QMoffet Jeffrey C · Lawrence, KSS/N 3111N5804USand Piper Air LLC · Endicott, NYBuilt 1970 · S/N 28-26632N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204N5804WBard Nathan R · Carlisle, PABuilt 1964 · S/N 28-1895N5804ZColyer Gregory W · San Rafael, CABuilt 1963 · S/N 22-9657N5805DEasley Clarence E · Pleasanton, KSS/N 22-4480N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5805QLam Michael · Bellaire, TXBuilt 1965 · S/N 768N5805UFoxtrot Three Flying Services LLC · Henderson, NVBuilt 1970 · S/N 28-26633N5805WPackett Robert E · Silverdale, WAFirst renewal noticeBuilt 1964 · S/N 28-1897N5806LSutphin Christoper F · Darlington, SCS/N AA5-0006N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205N58079Byrne David P · Ojai, CAS/N 24-1638N5807HCollins James T · Blossvale, NYBuilt 1949 · S/N 16-424N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5807QDavis Kevin B · Bellmawr, NJBuilt 1965 · S/N 769N5807SFisher Gary C · Louisburg, KSBuilt 1988 · S/N 24-3065N5808HReady Aim Flyer LLC · Hockessin, DEBuilt 1949 · S/N 16-425N5808LChristensen Donald R · Anchorage, AKBuilt 1971 · S/N AA5-0008N5808QSaathoff Michael A · Stockton, MOBuilt 1965 · S/N 3113N5808WYoung Victor G · Federal Way, WABuilt 1964 · S/N 28-1922N5809LNealy William · Heath, TXS/N AA5-0216N5809NN5809n Inc · New Castle, DES/N 14376N5809QSpicer Larry E · Milwaukee, WIS/N 770
Back to AD 81-18-04 R2