OpenAirDocs.org
AD 81-19-04

Registered aircraft · 22,662

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-19-04')
    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-19-04')
  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.

N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980N1001JBowmar Bruce C · Oxnard, CAS/N 24-3095N1003FChyatte Douglas · Saint Joseph, MOBuilt 1981 · S/N 24-1161N1003QKing Jeffrey J · Fort Worth, TXS/N 32R-7780217N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291N1006WFadem Justin Andrew · Williamsville, NYBuilt 1980 · S/N 24-1069N10074Linder Matthew L · Kalkaska, MIS/N 24-3096N1007NNewberg Edgar T · Hector, MNBuilt 1981 · S/N 24-1098N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100N1008LWilson Jeffrey M · Upper Arlington, OHBuilt 1981 · S/N 24-1103N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152N1009CFord Richard B · Hendersonville, NCBuilt 1981 · S/N 24-1105N1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994N100ABLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 1478N100BHChopper Aviation LLC · Cahokia Heights, ILBuilt 1958 · S/N TD-130N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050N100FBHoffman Swen · Sedalia, COBuilt 1963 · S/N D-7158N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900N100TOwyhee Pacific LLC · Kalispell, MTBuilt 1960 · S/N TD-350N100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255N100VFMeridian Aviation N100vf LLC · Mobile, ALBuilt 1977 · S/N 32R-7780539N100YVPalmy LLC · Lander, WYBuilt 1991 · S/N 243194N1010ARussell Jerald Trustee · Pampa, TXBuilt 1988 · S/N 24-3079N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145N1010GHyde Kinder · Montgomery, ALBuilt 1989 · S/N 24-3098N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092N1013USiry Stanley A · Burke, VAS/N 24-3101N10143Fatdog LLC · Voorhees, NJBuilt 1981 · S/N 24-1107N1014UStubblefield Daniel R · Lake Havasu City, AZS/N 24-3106N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N1015SJacobs Forest R · Vero Beach, FLS/N 24-3107N10176Abm Flights LLC · Pawleys Island, SCBuilt 1969 · S/N 18260141N1017FImwalle John N · Batavia, OHS/N 24-3108N1018CSotek LLC · Cheyenne, WYS/N 24-1110N1018MWilliams Arthur L · Amherst, OHBuilt 1990 · S/N 24-3153N10194N10194 Aviation LLC · Pleasant Hill, CAS/N 24-3109N101APatterson Mark T · Kodiak, AKBuilt 1959 · S/N 50486N101BBPolson Taylor M · Killeen, TXBuilt 1959 · S/N D-6076N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N101DWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 32R-7680399N101ECAtkinson Justin Shane · Fairbanks, AKBuilt 1978 · S/N 24-0593N101GHSan Diego Community College District · San Diego, CAS/N 18260875N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057
Back to AD 81-19-04