OpenAirDocs.org
AD 98-08-20

Registered aircraft · 920

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-08-20')
    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-08-20')
  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.

N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32N100FNMeander Air II LLC · Moon Township, PABuilt 2008 · S/N RK-566N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890N101WRAtlantic Jet Partners LLC · Pompano Beach, FLBuilt 1991 · S/N RK-41N103CWFlying Pigs LLC · Kinston, NCBuilt 1985 · S/N FA64N106KHExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2001 · S/N RK-323N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428N106SASkyline Aviation Services LLC · Miramar, FLBuilt 1990 · S/N FA206N107CZPeri Jets Inc · Roanoke, VABuilt 2006 · S/N RK-462N107SBN107sb Shares LLC · Liberal, KSS/N RK206N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792N1116RCtb Inc · Milford, INBuilt 1996 · S/N RK-116N111FWAcme Management Co · Fort Worth, TXS/N RK-102N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772N111SSFamily Time Machine LLC · Stuart, FLBuilt 1984 · S/N FA-4N112BJDg Group Aviation LLC · Bloomfield Hills, MIBuilt 1996 · S/N RK-112N116ADStone Holdings LLC · Towson, MDBuilt 2002 · S/N RK-338N119TCFlytat LLC · Missouri City, TXS/N RK-297N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121N124CMSolomon Mark Trustee · Wilmington, DEBuilt 1984 · S/N FA-24N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124N124PPBec-Faye LLC · Grimesland, NCBuilt 1994 · S/N RK-92N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977N125DJN125dj LLC · Modesto, CABuilt 2007 · S/N RK-531N125FSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1996 · S/N 125N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595N127EJExecutive Air Solutions Corp · Fort Lauderdale, FLS/N RK-127N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312N127QRBblbc LLC · Plano, TXBuilt 1988 · S/N FA-146N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036N128BGE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2000 · S/N 212N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581N12XPXpress-Air LLC · Cortland, NYS/N RK-458N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16N130WWWidewaters Beechjet Aviation LLC · East Syracuse, NYBuilt 1997 · S/N RK-136N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3N139LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 139N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585N145WFAircraft Propulsion Leasing LLC · Holland, OHBuilt 1993 · S/N DC-824BN149CCCianbro Corp · Baltimore, MDS/N FA-145N150RSRsa LLC · Myrtle Beach, SCS/N RK-373
Back to AD 98-08-20