OpenAirDocs.org
AD 94-01-06

Registered aircraft · 4,800

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

N100ACSmith Vicars & Co LLC · Charlottesville, VABuilt 2002 · S/N 5546N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32N100FLGhs Leasing Co · Newport Beach, CABuilt 2001 · S/N 5510N100FNMeander Air II LLC · Moon Township, PABuilt 2008 · S/N RK-566N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559N100LSAg Flyers Inc · Torrington, WYBuilt 1969 · S/N P-116N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44N100XVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 5320N10112Kc Aviation Stem Inc · Kansas City, MOS/N 193L1064N101KFTravers 6 LLC · Chesterfield, MOS/N 5564N101NDFlorida Jet Parts LLC · Fort Lauderdale, FLBuilt 1994 · S/N 037N101RERegistered aircraftBuilt 2017 · S/N 6101N101SGSe Aviation LLC · Tupelo, MSBuilt 2001 · S/N BB-1785N101SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 161N101WFBl Custom Equipment LLC · Cincinnati, OHBuilt 2003 · S/N 197N101WRAtlantic Jet Partners LLC · Pompano Beach, FLBuilt 1991 · S/N RK-41N1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N P-78N102DADelta Air Lines Inc · Atlanta, GABuilt 1982 · S/N 22214N102DBFinch Air LLC · Midland, TXBuilt 1996 · S/N BB1537N102LJRegan Aviation LLC · Stateline, NVBuilt 1997 · S/N 102N102UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1998 · S/N 0844N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443N1038S1038s LLC · Austin, TXBuilt 2008 · S/N 5782N103CWFlying Pigs LLC · Kinston, NCBuilt 1985 · S/N FA64N103JLThunderun Aviation Corp · Buffalo, NYBuilt 1990 · S/N 026N103TDTrigger Air LLC · Wilmington, DES/N 31-006N103USUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0861N104CXSli Aircraft Leasing Inc · Spokane Valley, WABuilt 1982 · S/N BB1004N104HRXyrec Inc · San Antonio, TXNon-citizen corporation, flight hours not reportedS/N 21525N104KPLakefront Holding LLC · Racine, WIS/N LJ-1719N104RJHalrive Air LLC · Boca Raton, FLBuilt 2012 · S/N 422N104UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0863N105BKJetcom LLC · Lemon Grove, CABuilt 1989 · S/N 070N105UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0868N1068KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1448N106DDHlp Aviation LLC · Shreveport, LABuilt 2005 · S/N LJ-1738N106FFAerial Holdings Lj Inc · Wilmington, DEBuilt 2010 · S/N 375N106GBHardhead Aviation LLC · Midland, TXBuilt 1986 · S/N BB-1249N106KHExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2001 · S/N RK-323N106SASkyline Aviation Services LLC · Miramar, FLBuilt 1990 · S/N FA206N1074GEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1534N1076KGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1461N1079DGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1462N107CZPeri Jets Inc · Roanoke, VABuilt 2006 · S/N RK-462N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199N107SBN107sb Shares LLC · Liberal, KSS/N RK206
Back to AD 94-01-06