OpenAirDocs.org
AD 97-22-08

Registered aircraft · 55

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

N100UUQualitair LLC Trustee · MichelstadtS/N 1000N108MAGrizzly Air Service Inc · Paris, TXS/N 792N116SKAir Methods LLC · Greenwood Village, COBuilt 1995 · S/N 116N124UVGuardian Flight LLC · Lewisville, TXS/N 124N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153N156PCIdaho Skyworks LLC · Walnut Creek, CABuilt 1976 · S/N 777N156SBSpark Aviation LLC · West Harrison, NYS/N 156N162PBPapa Bravo Aviation LLC · Fort Lauderdale, FLBuilt 1996 · S/N 162N19TXPerry James · Monroe, WAS/N 684N1TCMarcare Aviation LLC · Gardnerville, NVBuilt 1995 · S/N 130N208CGAspen Homes And Development LLC · Coeur D Alene, IDBuilt 1995 · S/N 132N217EBRapids Camp Lodge Inc · King Salmon, AKBuilt 1996 · S/N 154N2185MFreefall Express · Gardiner, NYBuilt 1968 · S/N 687N222CMBriar Lakes Productions Inc · Palestine, TXBuilt 1995 · S/N 111N228JDValiair Limited Company Trustee · Casper, WYBuilt 1998 · S/N 220N22MAMiair Inc · Lewes, DES/N 785N263RSNorthern Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 112N312BCWorldwide Option LLC · Lewes, DEBuilt 1994 · S/N 101N312PCPacific Real Estate Consulting LLC · Irvine, CABuilt 1996 · S/N 141N338SBSwitchback Aviation LLC · Cody, WYBuilt 2007 · S/N 953N365BTJaars Inc · Waxhaw, NCBuilt 1971 · S/N 729N409LTHarmsantos Enterprises LLC · Park City, UTS/N 1091N423MGMike Gulf LLC · Fort Lauderdale, FLBuilt 1996 · S/N 140N444CMDl Aviation Solutions LLC · Jacksonville, FLBuilt 1996 · S/N 152N462PCMaior Vado Citius LLC · Friendswood, TXBuilt 2002 · S/N 462N488WYFlexible Flyer LLC · Cody, WYBuilt 2017 · S/N 1012N55BKPc 12 LLC · Sterling, VABuilt 1996 · S/N 160N55WPRichardson Farms Outfitters Inc · Pittsfield, ILBuilt 1995 · S/N 127N610GHHtc Aviation LLC · Lititz, PABuilt 2003 · S/N 103N623ACViolich Farms Inc · Kentfield, CAS/N 722N632SAPerry Kathryn C · Sultan, WAS/N 632N699SAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1968 · S/N 669N6WLAurora Air LLC · Kalispell, MTBuilt 1975 · S/N 743N732SBAero Shares LLC · Excelsior, MNBuilt 2001 · S/N 410N776PCTechnical Applications & Consulting LLC · Topeka, KSS/N 775N77DQSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 921N79CSFord Gt Holdings LLC · Fort Dodge, IABuilt 1995 · S/N 125N802HSSecurity Holdings LLC · Richmond, VABuilt 1995 · S/N 118N80LHLochsa Aviation LLC · Missoula, MTBuilt 1978 · S/N 801N812PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 106N814PAPriority Air Charter LLC · Kidron, OHBuilt 1994 · S/N 110N8171ELazy Ta Legend Aircraft LLC · Wilmington, DES/N 859N8171KPerry Kathryn C · Sultan, WAS/N 750N84GEHighwings LLC · Fargo, NDBuilt 2001 · S/N 408N856FAPlane Fun Inc Tr Trustee · Snellville, GABuilt 1986 · S/N 856N900HSBizair LLC · Wilmington, DEBuilt 1996 · S/N 136N903SMSterling Air Service LLC · Corpus Christi, TXBuilt 1995 · S/N 131N911VMGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N 150N913NMSan Juan Regional Medical Center Inc · Farmington, NMBuilt 1997 · S/N 169
Back to AD 97-22-08