AD 2002-11-07

Registered aircraft · 1,512

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

N2150LB-58 Inc · Albany, GAS/N TH-781N215CHKld Air LLC · Charlotte, NCBuilt 1977 · S/N TE-1116N219CHSteel 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-980N21JPDmmag LLC · Windermere, FLBuilt 1977 · S/N TE-1092N21LPLp Aviation Inc · Wilmington, DEBuilt 1977 · S/N TH-848N21MFOsgood Air LLC · Hays, KSBuilt 1998 · S/N TH-1871N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77N21YMCape Fear Transport Inc · Elizabethtown, NCS/N TH-2005N2205LAerocare LLC · Oak Ridge, TNBuilt 1976 · S/N TE-1083N221CHBas Part Sales LLC · Greeley, COS/N TH-2103N2224DHanger South Aviation LLC · Paragould, ARS/N TH-1824N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384N222PGShokoohi Mehdi · Anaheim Hills, CABuilt 1973 · S/N TE-912N222RBwr 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-857N22334Fredericks Hall Aviation LLC · Mineral, VABuilt 1977 · S/N TE-1111N223KMWithrotor Aviation Inc · Lakeview, ORBuilt 1974 · S/N TH447N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339N225TAN225ta LLC · Loganville, GABuilt 1970 · S/N TH-64N2264LWoolum Stephanie · Varney, WVBuilt 1976 · S/N TH-771N2271LBurchinal Skyler · Brookston, TXS/N TJ-71N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344N2288LCherryhill Aviation Inc · Freetown, INS/N TJ-70N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N22917Paducah Midstream Grocery Inc · Paducah, KYBuilt 1978 · S/N TE-1118N229TARemes Stephen · Northfield, MNBuilt 1978 · S/N TH-887N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263N2333BN2333b 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-1848N234MGDubin Wayne M Trustee · Fort Myers, FLBuilt 1977 · S/N TE-1104N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865N23571Dlat Holdings LLC · Allen, TXBuilt 1977 · S/N TE-1120N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134N235SMTriniair LLC · Warner Robins, GAS/N TH-926N237DCHinkle Airspray Inc · Cavalier, NDBuilt 1978 · S/N TJ-133N23KMR H Phillips Trucking Co Inc · Shelby, OHS/N TH-2116
Back to AD 2002-11-07