AD 74-19-01

Registered aircraft · 2,673

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

N122TEBouchillon James R · Hanahan, SCBuilt 1972 · S/N 32-7340044N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268N1239TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250270N123BEBald Moutain Aviators · Fredericktown, MOBuilt 1967 · S/N 32-40271N123LUSutton Aircraft Salvage LLC · Palmer, AKS/N 32394N123MFAronhalt Daniel E · Columbus, INBuilt 1968 · S/N 32-1069N123TXGofly Corporation · Port Ewen, NYBuilt 1968 · S/N 28-11108N123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 32-7940258N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579N1293TN1293t LLC · Wilmington, DES/N 34-7250283N1297HHop A Chopper Inc · Dover, DES/N 32-7700010N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112N129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 32-7440057N130BWPobiega Michael J · Fort Mill, SCBuilt 1970 · S/N 32-40963N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124N1327TCedel Solutions LLC · Austin, TXBuilt 1972 · S/N 32-7240113N132KMKing General Contractors Inc · Bristol, VAS/N 32-7940161N132LESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-40038N133PTKittle David · Siloam Springs, ARS/N 32-7440136N1343TWestern Cherokee Six LLC · Fort Collins, COBuilt 1972 · S/N 32-7240114N134ACSkyline Solutions Inc · Deland, FLBuilt 1972 · S/N 34-7350014N1355TRmf Trucking LLC · Tuscaloosa, ALBuilt 1972 · S/N 32-7240115N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301N1380TN1380t LLC · Wilmington, DEBuilt 1972 · S/N 34-7250302N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311N1409XHolmberg Shane A · Fairbanks, AKBuilt 1975 · S/N 32-7540155N140JGBarros Vincent · Kissimmee, FLBuilt 1974 · S/N 32-7400043N1419XWhitman Aviation LLC · Morganville, NJS/N 32-7540160N141ANWells Ryan · Holdrege, NES/N 32-7940062N1421TBurr Charles R Jr · Palm Bay, FLBuilt 1972 · S/N 34-7250314N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043N14258Bayshore Aviation LLC · Saint Petersburg, FLS/N 34-7350180N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038N1435TWaters Nicholas T · Claypool, INBuilt 1972 · S/N 32-7240121N1436TDeland Aviation LLC · Deland, FLBuilt 1972 · S/N 34-7250317N143DWCardinal Aviation LLC · Towson, MDBuilt 1974 · S/N 32-7440164N1450XHopkins David M · Bell Buckle, TNBuilt 1975 · S/N 32-7500042N1452TAbacus Automation · Bennington, VTS/N 32-7240122N1465HHolland Ray A · Blue Earth, MNS/N 28-7710002N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040N146MBMlc Flying Club LLC · Saint Peters, MOBuilt 1978 · S/N 32-7840160N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985N1474TStella Stephen G DBA · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240125
Back to AD 74-19-01