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.

N12EEArizona Cloudbusters Inc · Mesa, AZS/N 18280038N130MEPetersens Marine Services Corp · Ridge, NYBuilt 2000 · S/N 18280686N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189N133VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281190N134DBBlue Skies27 LLC · Los Angeles, CABuilt 2000 · S/N 18280808N134VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281191N135VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281192N136VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281193N137MACivil Aviation Inc · Waukesha, WIBuilt 1997 · S/N 17280146N137VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281194N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503N139RABeach Cruisers LLC · Ormond Beach, FLBuilt 1999 · S/N 18280614N146NEAngle Mark W · Lake Orion, MIBuilt 1998 · S/N 18280221N146WHAmick Ralph O · Hatteras, NCS/N 18280304N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185N151BSEvans Linda J · North Wales, PABuilt 2001 · S/N 18280934N151MELoweth William A · Noank, CTBuilt 2000 · S/N 18280722N152MEChamp Jerry D · Belton, SCBuilt 2000 · S/N 18280723N157RDBoman & Kemp Lc · Ogden, UTBuilt 1999 · S/N 18280646N157SMHumphreys James F · Charleston, WVBuilt 1998 · S/N 18280157N157ZZRegistered aircraftS/N 18280402N1589DN1589d LLC · Stuart, FLBuilt 2005 · S/N 17281255N158JRCollins Stephen Neil · Clancy, MTS/N 18280051N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256N159DRPiedmont Flight Inc · Winston Salem, NCBuilt 1998 · S/N 18280128N159FSEastern Kentrucky University · Richmond, KYBuilt 1999 · S/N 17280816N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192N162TCDrummond E Garrison · Parksley, VABuilt 1998 · S/N 18280164N163JBBender W Jeffrey · Ocala, FLBuilt 2000 · S/N 18280715N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752N167SJAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280167N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188N168DSVertx Fleet Holdings LLC · San Diego, CABuilt 1997 · S/N 18280032N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703N17274University Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280353N17297Barrier William · Pensacola, FLBuilt 1997 · S/N 17280140N172BFLewis University · Romeoville, ILBuilt 1997 · S/N 17280175N172DRCunningham Darius L · Sterling, VABuilt 1997 · S/N 17280272N172EFNorth Shore Aero Club Inc · Beverly, MABuilt 2000 · S/N 17280876N172FNSkyhawk 172 LLC · Eugene, ORS/N 17280004N172GHNebel & Son Aircraft Leasing Inc · Jacksonville, FLBuilt 1997 · S/N 17280192N172HPSpinnaker Aviation LLC · Conroe, TXBuilt 1997 · S/N 17280274N172JEBachman Aviation Inc · Winter Haven, FLBuilt 1997 · S/N 17280289
Back to AD 98-01-01