OpenAirDocs.org
AD 63-22-03

Registered aircraft · 37,004

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

N10006Coutches Robert Hercules DBA · Livermore, CABuilt 1955 · S/N BG-72N1000MValdez Raymond G · Las Vegas, NMS/N 108-3741N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000N1000THaughton Douglas L · Gig Harbor, WABuilt 1957 · S/N D-4980N1000YBarkhimer James C · Iraan, TXBuilt 1954 · S/N 30999N1001WRight Downwind Inc · Ropesville, TXBuilt 2006 · S/N 60208N10020Stephens David Sr · Plains, MTBuilt 1995 · S/N 20044CN1002HSmith Michael S · Anchorage, AKBuilt 1997 · S/N 23038CN1002NMobley John E · Newark, ARS/N 21005CN1002SKucel R Scott · Dallas, TXBuilt 1995 · S/N 20056CN10039Vanderpool Wayne R · Adams, NYS/N 22275N1005LO'Neal Gregory A · Saint Cloud, FLBuilt 1960 · S/N 248N10069Silvestri Leonardo · Ellicott City, MDBuilt 1996 · S/N 20050CN1006ESpot-Air LLC · Burlington, TXBuilt 1977 · S/N 244-77N1006QMills James A · Dearborn, MIBuilt 1979 · S/N PS-1N1007CVee Two Inc · Merritt Island, FLBuilt 1992 · S/N 10089N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411N1007UKallam Jerry · Palmer, AKBuilt 1998 · S/N 23047CN1008KAu Jerry · Manhattan Beach, CAS/N 10168N1008WRay Jonas · Palmer, AKS/N 23022CN1009PFerrier William T · Woodland, CABuilt 1958 · S/N 34994N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194N100BHChopper Aviation LLC · Cahokia Heights, ILBuilt 1958 · S/N TD-130N100BUJav Aviation LLC · Landenberg, PABuilt 1997 · S/N 19N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536N100CWCoffin Craig T · Glendale, CABuilt 1979 · S/N 1N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957N100GQUsda-Aphis-Ws · Cedar City, UTBuilt 2010 · S/N CC18-0041N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509N100HUSimpson Jared S · Malad City, IDBuilt 1996 · S/N 1319N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113N100MMFarmer Aviation LLC · Milan, MIS/N 33611N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186N100MVBensen John A · Greenville, NYBuilt 1972 · S/N 11972N100NTBk Aviation LLC · Reno, NVBuilt 2005 · S/N 60438N100QRichmond Suzanne L · North Hills, CABuilt 1971 · S/N KL-2N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185N100RVMaule Group Ltd · Wilmington, DES/N 20029CN100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900N100TOwyhee Pacific LLC · Kalispell, MTBuilt 1960 · S/N TD-350N100WYMcatee Mark D · Casper, WYBuilt 1959 · S/N 56439N1011LColburn Paul A · Hillsboro, NHBuilt 1960 · S/N 254N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092N1013QCarrera Aviation LLC · Wilmington, DEBuilt 1996 · S/N 21006CN1014GUpchurch Kenneth A · Baxley, GABuilt 1996 · S/N 20049CN1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650
Back to AD 63-22-03