OpenAirDocs.org
AD 84-19-03 R1

Registered aircraft · 5,075

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:84-19-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-19-03-R1')
  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.

N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063N377HAGrasse Louis Phillip Trustee · Saint Louis, MOBuilt 2004 · S/N T20608499N377HCHigh Altitude Aviation LLC · High Point, NCBuilt 2002 · S/N 4636332N377JRTrinity Aviation LLC · Oklahoma City, OKBuilt 1969 · S/N 32-11N377MEBrandywine Enterprises Lp · Beverly Hills, CABuilt 2000 · S/N T20608226N377RTElevated Aviation LLC · Silt, COS/N 3257377N377SMJrt Flying Co · Roanoke, VABuilt 1977 · S/N 32R-7780223N377USEaton Brian · Tampa, FLBuilt 2005 · S/N 27-0337N3785ERegistration Pending · Sabin, MNRegistration pendingS/N 36-7860077N378HPBelair Venice Aviation LLC · Osprey, FLBuilt 2004 · S/N 3257347N378MECamelot Aviation LLC · Phoenix, AZBuilt 2000 · S/N T20608228N378MMBento De Deus Amarildo · Margate, FLBuilt 1978 · S/N 31-7812118N378MSJulius Kaleb · Tucson, AZBuilt 2002 · S/N T18208082N379BFDay Darrell Rodney · Sahuarita, AZBuilt 2004 · S/N T18208253N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORBuilt 2005 · S/N T18208379N379HPLiquid Transport Inc · Camilla, GABuilt 2004 · S/N 3257353N37CKSale Reported · Saint Thomas, VISale reported, pending cancellationBuilt 1962 · S/N 500A-1251-76N37GCKoumi Enterprises LLC · Houston, TXBuilt 2002 · S/N 3257273N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114N37RTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1997 · S/N 4636082N3800WJdj Transport LLC · Wilmington, DEBuilt 1966 · S/N 32-40128N380CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 3257080N38127Trager Limestone LLC · Chillicothe, MOS/N 32R-7780387N381CBGrubbs Steven O · Bellaire, TXBuilt 1981 · S/N 32R-8129068N381HPHopkins George · West Covina, CABuilt 2005 · S/N 3257374N381KHPhoenix Fire Protection LLC · Nampa, IDBuilt 2005 · S/N 27-0345N38205Albright John A · Richmond, INBuilt 1977 · S/N 32R-7780403N382HP382 Hp LLC · Pt Pleasant Beach, NJBuilt 2006 · S/N 3257411N382JMGullicksrud Mark Robbe · Strum, WIBuilt 1981 · S/N 32R8229026N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415N3838EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960068N3839EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960069N383CSven 1 LLC · Center Moriches, NYBuilt 2001 · S/N 3257258N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445N385TCLiebl Holdings LLC · Claremore, OKS/N T18208385N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130N38617Bros Flying Low LLC · Kalispell, MTS/N 32R-7780447N38725Maynard Geoffrey · New Marlborough, MABuilt 1977 · S/N 32R-7780465N38746Campbell David A Trustee · Bolivar, MOBuilt 1977 · S/N 32R-7780466N387TCBass Joel W · Okeechobee, FLBuilt 2005 · S/N T18208386N38854Schmidt Ryan A · Medinah, ILFirst renewal noticeBuilt 1977 · S/N 32-7740098N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021N388TWeimer David J · Knightstown, INBuilt 1973 · S/N 32-7440044N3891FJjcw Aviation Inc · Athens, TXBuilt 1976 · S/N 32R-7680407N38997Blg Air Inc · State College, PABuilt 1977 · S/N 32R-7780496N38KCChanney Aviation Group LLC · Las Vegas, NVBuilt 1983 · S/N 31-8352033N38TCInternational Albatros Holdings Corp · Cottonwood, AZBuilt 1967 · S/N 31-96N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117N3915XKb Aviation LLC · Lewes, DEBuilt 1975 · S/N 32-7540182
Back to AD 84-19-03 R1