AD 2002-11-03

Registered aircraft · 502

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-03')
    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-03')
  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.

N4515AB&R Aerial Crop Care Inc · Connell, WAS/N 502-0095N4525QAg Flyers Inc · Torrington, WYS/N 502-0100N45313Registration Pending · Southampton, NJRegistration pendingS/N 502-0103N4536QHoppe Air LLC · Beaman, IAS/N 502-0106N4537XPontiac Flying LLC · Pontiac, ILS/N 502-0110N4540YTlc Flying Inc · Colfax, WABuilt 1990 · S/N 502-0120N45461Shannon Agricultural Flying Inc · Clarksdale, MSBuilt 1990 · S/N 502-0124N45506Mid Continent Aircraft Corp · Hayti, MOBuilt 1991 · S/N 502-0132N4550NNewberg Sky Spray LLC · Hector, MNBuilt 1991 · S/N 502-0131N4551MCady Leslie L · Rock Falls, ILBuilt 1991 · S/N 502-0133N477LACarlson Production Services LLC · Norcross, MNBuilt 2024 · S/N 502A-3477N479LARedline Aviation Lnc · Sioux City, IABuilt 2024 · S/N 502A-3479N486FAA+ Aviation Services LLC · Garden City, KSBuilt 2014 · S/N 502B-2962N497JBNeal Aircraft Inc · Slaton, TXBuilt 2008 · S/N 502B-2630N5001LAcme Aerial Application LLC · Seneca Falls, NYBuilt 1998 · S/N 502B-0513N5002JBcs Aerial LLC · Butler, MOBuilt 1998 · S/N 502B-0498N5003CCrop Air LLC · Eaton, COS/N 502B-0396N5004VTim Whitfield Aviation Inc · Fairfield, NCBuilt 1996 · S/N 502B-0400N5007GWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1997 · S/N 502B-0417N5009SBrignac Flying Service LLC · Columbus, MSBuilt 1996 · S/N 502B-0402N5010JGc Aviation LLC · Kalispell, MTBuilt 1997 · S/N 502B-0419N5012CVan Namen Jonathan E · Benoit, MSBuilt 1997 · S/N 502B0411N5013CAir Tractor Inc · Olney, TXS/N 502A-3648N5018JRegistration Pending · Littlefield, TXRegistration pending, pending cancellationBuilt 1997 · S/N 502B-0432N5019AReabe Spraying Service Inc · Plover, WIBuilt 1997 · S/N 502B-0415N501MHBeta Ag Inc · Ralls, TXBuilt 2024 · S/N 502B-3473N5022CCleveland Air Service Inc · Cleveland, MSBuilt 1998 · S/N 502B-0479N5022SSchneider Ag Inc · Rugby, NDBuilt 2023 · S/N 502A-3420N502ADReabe Spraying Service Inc · Plover, WIBuilt 2016 · S/N 502B-3040N502AGBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 502A-3274N502AMScott Precision Aerial LLC · Oberlin, KSBuilt 2010 · S/N 502B-2698N502ARAir Care Leasing LLC · Lamar, COBuilt 1992 · S/N 502-0165N502BACrop-Serv Inc · Meade, KSBuilt 2010 · S/N 502B-2699N502BBStott Aerial Spray Inc · Jefferson, IABuilt 2018 · S/N 502A-3134N502BMPrecision Ag Air LLC · Lake Village, ARBuilt 1988 · S/N 502-0023N502BTRainey Aerial Ag Service Inc · Obion, TNBuilt 2009 · S/N 502B-2658N502CKPot Hook Leasing LLC · San Benito, TXBuilt 2022 · S/N 502A-3345N502CMWheels Down LLC · Buffalo Center, IABuilt 2010 · S/N 502B-2706N502CPMcelwain Russell · Lancaster, KSBuilt 2008 · S/N 502B2632N502DBDbl LLC · Hays, KSBuilt 2014 · S/N 502B-3007N502DEDavis Levi · Gratiot, WIBuilt 2009 · S/N 502B-2661N502DLCkw Aviation LLC · Dalhart, TXBuilt 1992 · S/N 502A-0176N502DSAir Dusters Inc · Roggen, COBuilt 1988 · S/N 502-0017N502EMDeby Ag Leasing Lp · Wakarusa, INBuilt 2022 · S/N 502A-3363N502FATaylors Flying Service Inc · Utica, MSBuilt 1993 · S/N 502-0217N502FDBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 502A-3402N502FFHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1998 · S/N 502B-0534N502GDBrett'S Spray Service Inc · Onida, SDBuilt 2007 · S/N 502B-2620N502GKMeyer Aviation Inc · Whittemore, IABuilt 2012 · S/N 502B-2794N502HABlackhawk Air LLC · La Porte City, IABuilt 2018 · S/N 502A-3144
Back to AD 2002-11-03