AD 2000-22-18

Registered aircraft · 914

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

N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626N210DAStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N TH-1067N2110LMalco Power Design Co Inc · La Marque, TXS/N TH-761N2119LCannon Thomas W · Tiki Island, TXBuilt 1976 · S/N TH-759N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995N212CHFlycarolina Ll · Concord, NCBuilt 1980 · S/N TH-1165N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950N213CHEz Aviation LLC · Morrisville, NCS/N TH-2079N2143JTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N TH-1855N2146LDm Group LLC · Troutman, NCBuilt 1976 · S/N TH-778N214CHFlycarolina LLC · Concord, NCBuilt 1980 · S/N TH-1160N214KPBnb Aviation LLC · Chesterfield, MOBuilt 1999 · S/N TH-1894N2150LB-58 Inc · Albany, GAS/N TH-781N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990N219GMStewart Michael A · Washington, DCBuilt 1988 · S/N TH-1536N21DAW Squared Holdings LLC · Edmond, OKBuilt 1978 · S/N TH-980N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848N21MFOsgood Air LLC · Hays, KSBuilt 1998 · S/N TH-1871N21YMCape Fear Transport Inc · Elizabethtown, NCS/N TH-2005N221CHBas Part Sales LLC · Greeley, COS/N TH-2103N2224DHanger South Aviation LLC · Paragould, ARS/N TH-1824N222RBwr Aircraft LLC · Paramus, NJBuilt 2001 · S/N TH-1977N222RBM & B Llp · Iowa City, IABuilt 1990 · S/N TH-1592N222RGVaerus Jet Sales LLC · Topeka, KSBuilt 1994 · S/N TH-1698N222RZP & M Reis Trucking Inc · Nantucket, MABuilt 1977 · S/N TH-857N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N229TARemes Stephen · Northfield, MNBuilt 1978 · S/N TH-887N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835N233CTHoneycutt Danny · Angier, NCBuilt 1984 · S/N TH-1433N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827N235SMTriniair LLC · Warner Robins, GAS/N TH-926N23KMR H Phillips Trucking Co Inc · Shelby, OHS/N TH-2116N23PCHenderson Aviation Inc · Abingdon, VAS/N TH-2071N23PVLake Dana · Boxford, MAFirst renewal noticeBuilt 1987 · S/N TH-1513N241WSSun Moon Star LLC · Springfield, MOBuilt 1999 · S/N TH-1922N242RCN242rc LLC · Miami, FLBuilt 1972 · S/N TH-248N2458RKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2004 · S/N TH-2089N25627Sutter Jacob O · Roland, ARBuilt 1973 · S/N TH-295
Back to AD 2000-22-18