AD 98-01-01

Registered aircraft · 1,289

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:98-01-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:98-01-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.

N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CABuilt 1998 · S/N 17280389N199RAN199ra LLC · Huntington Woods, MIBuilt 1999 · S/N 18280636N1LYAll About Lawns Inc · Sebring, FLBuilt 2000 · S/N 18280826N2017CHigher Flyer LLC · Northport, ALBuilt 1999 · S/N 18280463N201THG & M Aircraft Inc · Wheat Ridge, COBuilt 1997 · S/N 17280201N2054SLewis University · Romeoville, ILBuilt 2004 · S/N 17281203N207SADyer LLC · Dyer, TNBuilt 1998 · S/N 18280140N2081JWings Over Texas Holdings LLC · Denton, TXS/N 17280995N2083FDetroit Public Schools Community District · Detroit, MIS/N 17280671N2093BTextron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18280041N2098AAtp Aircraft 1 LLC · Wilmington, DEBuilt 1999 · S/N 17280762N2099DRollins Dale G · Covington, LABuilt 2004 · S/N 17281204N20KJOxford Flying Club Inc · Oxford, CTBuilt 1998 · S/N 18280143N2103TIasco Flight Training Inc · Redding, CABuilt 2004 · S/N 17281205N2108ZPinnacle Aviation Services Inc · Encinitas, CABuilt 2004 · S/N 17281207N210BCDurant Bruno Gerard · Coalmont, TNBuilt 1998 · S/N 18280308N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676N2119EMid-Island Air Service Inc · Ronkonkoma, NYBuilt 2004 · S/N 17281212N211MRPowerbelt LLC · Glendale, CABuilt 2000 · S/N 18280813N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046N2145TCff Air Inc · Wilmington, DES/N 17281174N216DCDornink Steven R · Birchwood, WIBuilt 2000 · S/N 18280898N216JKKelly James C Jr · Bonaire, GABuilt 2000 · S/N 18280719N2173ZTegridy Equipment Leasing LLC · Aurora, ORBuilt 2004 · S/N 17281216N218DEFrysinger Investments LLC · Hudson Oaks, TXBuilt 2000 · S/N 18280733N21SZVista Air Inc · Pacoima, CABuilt 1998 · S/N 17280653N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681N222MTJw182 LLC · Kalispell, MTBuilt 1998 · S/N 18280108N222VWCool Beans LLC · Newtown, PAS/N 18280085N222XMSchlasinger Larry DBA · Chetek, WIBuilt 1998 · S/N 18280119N2233MPutnam John P · Weirsdale, FLS/N 18280069N223BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280950N223HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 17281112N223MEChem-Air LLC · Shreveport, LABuilt 2000 · S/N 18280746N2242CCac Of Ar LLC · White Hall, ARBuilt 2000 · S/N 18280779N2254URaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280684N2268AAerofeather Aviation Inc · Suffolk, VABuilt 1998 · S/N 17280686N2272VGryffin Ventures LLC · Jupiter, FLBuilt 2000 · S/N 17280839N2274BAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1999 · S/N 17280689N227RJFrost Cavin B · Odessa, TXS/N 18280383N228JPMazel Wings LLC · Camden, DEBuilt 2000 · S/N 18280711N2316TAircraft Solutions Group LLC · Englewood, COBuilt 1999 · S/N 17280694N231PABone Jason T · Bulverde, TXBuilt 2000 · S/N 18280848N23203Wings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 17280696N232MEDunbar Joseph · Greensboro, NCBuilt 2000 · S/N 18280749N232SBEagle Crest 2sb LLC · Milton, DEBuilt 1998 · S/N 18280211N23383Performance Auto Body Inc · Knightdale, NCBuilt 1998 · S/N 18280406
Back to AD 98-01-01