OpenAirDocs.org
AD 2006-10-21

Registered aircraft · 44,908

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

N113CJMarshall Joshua · Chuckey, TNBuilt 1979 · S/N R18201076N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N113GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881455N113HMAkins Tal M · Register, GABuilt 1976 · S/N 32-7640084N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027N113JGTaveniku Mikael · Painted Post, NYS/N DM0113N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000N113JKBusciglio Daren A · Tampa, FLBuilt 2009 · S/N 21369N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615N113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 3134N113KCGolden Valley LLC · Missoula, MTBuilt 2018 · S/N 41573N113MAMyllyla Ray J · Woodland Hills, CABuilt 1999 · S/N 304N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193N113MXN113mx LLC · Redding, CAS/N 002N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422N113PCProp & Jet Air Museum Inc · Romoland, CABuilt 1982 · S/N 1N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN113PVVaneau Philip M · Kerrville, TXBuilt 1987 · S/N DENTON GIVENS 1N113SJGlumac Stanley Jr · Grindstone, PABuilt 1993 · S/N 21400N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298N113TLKramer David P · Lebanon, TNBuilt 2003 · S/N T18208219N113TRBell Thomas E · Henniker, NHBuilt 1976 · S/N 32R-7680207N113UDRv8rs Anonymous LLC · Cincinnati, OHBuilt 2002 · S/N 80459N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1140XReaper LLC · Britton, MIBuilt 1975 · S/N 32-7540147N11414Van Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208413N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185N1144LComposite Sign Products Inc · Zeeland, MIBuilt 1964 · S/N 306N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191N1146LSak Aviation LLC · Cheney, KSBuilt 1981 · S/N 24-1198N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N1147LLandry Lonny Reid · Fort Worth, TXBuilt 1964 · S/N 309N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N114ADBailey Walter A III · Cincinnati, OHBuilt 1998 · S/N 20020N114ANHake Scott W · Swoope, VABuilt 1978 · S/N 14396
Back to AD 2006-10-21