OpenAirDocs.org
AD 2002-21-13

Registered aircraft · 579

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-21-13')
    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-21-13')
  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.

N3387VPermian Basin Blue Sky Inc · Odessa, TXBuilt 1947 · S/N D-861N3391VWelsh Kevin J · Roseburg, ORFirst renewal noticeS/N D-865N3394VDavis Sherald L · Baytown, TXFirst renewal noticeS/N D869N3398VWiger Theodore L · Falcon Heights, MNBuilt 1947 · S/N D-873N3403VBernier Brian Matthew · Austin, TXBuilt 1947 · S/N D-879N3405VRegistration Pending · Salem, MORegistration pendingBuilt 1947 · S/N D-881N354DEHomesley Jonathan Edward · Mcgregor, TXBuilt 1949 · S/N D-2077N35EFFourt Rob · Bentonville, ARBuilt 1949 · S/N D-1964N35JXAc Holdings II Inc · Lewes, DES/N D754N35VTGeneral Aviation Modifications Inc · Ada, OKS/N D-696N363Tolen Dave · Gallatin, MOS/N D-252N369RBWorman Cody Gene · Fort Wayne, INS/N D-2384N3703NGreystone Enterprises Inc · Oklahoma City, OKBuilt 1947 · S/N D-909N3705NRogers Laurin A · Kennewick, WABuilt 1947 · S/N D-911N3722NSchmidt Lyle W · Los Lunas, NMS/N D-931N3725NIvy James H III · Seligman, AZS/N D-934N3731NBerka George · Waterbury, CTBuilt 1947 · S/N D-940N3733NHorning Richard H · Galion, OHBuilt 1947 · S/N D-943N3734NSelect Aerospace Industries · Weyers Cave, VABuilt 1947 · S/N D-944-R9N3738NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-948N3740NCrimmins Christopher E · Franklin, TNBuilt 1947 · S/N D-956N3741NBruzzone Daniel E · Rllng Hls Est, CABuilt 1947 · S/N D-959N3742NAsp Kenneth J · Thief River Falls, MNBuilt 1947 · S/N D-960N3745NFlivver Classic Aviation LLC · Tipp City, OHBuilt 1947 · S/N D-963N3746NColvin Clu D · Big Cabin, OKS/N D-964N3754NColyer Gregory W · San Rafael, CABuilt 1947 · S/N D-973N3756NLloyd John M · West Allis, WIBuilt 1947 · S/N D-976N3758NMeyer Jeremy L · Conway Springs, KSS/N D-978N3777JBeltz Richard D · Lehighton, PABuilt 1949 · S/N D-1908N3777NBonanza Parts Inc · Davis, CABuilt 1947 · S/N D-999N3778NOliphant Jack · Fort Collins, COBuilt 1947 · S/N D-1000N3781NOkeefe John Thomas · Winthrop, WABuilt 1947 · S/N D-1003N3787NAircraft Partner Holdings Inc Trustee · BerlinBuilt 1947 · S/N D-1010N378YMeng Steven Jones · Garden Grove, CAS/N D-2680N3791NLabs Kevin A · Citrus Heights, CABuilt 1947 · S/N D-1014N3798NAviation Business Corp · Saint Louis, MOBuilt 1947 · S/N D-1160N3807NTanner Byron D · Saint Amant, LABuilt 1947 · S/N D-1035N3812NHixon Craig · Sayre, OKBuilt 1948 · S/N D-2037N3814NChapman Stuart M · Vernon, COBuilt 1947 · S/N D-1043N3815NEllett Tommy A · Ferriday, LABuilt 1947 · S/N D-1044N3816NBailey James · Lewisburg, TNBuilt 1947 · S/N D-1045N3818NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1947 · S/N D-1047N3822NLohmann Heinrich F · Saint Louis, MOBuilt 1947 · S/N D-1054N3825NMorrison Benjamin F · Godley, TXBuilt 1947 · S/N D-1062N3826NWahl Christopher S · Jerseyville, ILS/N D-1063N3829NCostello John J Jr · Carlsbad, CABuilt 1947 · S/N D-1066N3831NTilghman Charles R Jr · Van Alstyne, TXBuilt 1947 · S/N D-1068N3835NHaraway David D · Tulsa, OKBuilt 1947 · S/N D-1072N3843NShafer John P · Bridgeport, OHS/N D-1081N3850NHayden Robert P · West Fargo, NDBuilt 1947 · S/N D-1088
Back to AD 2002-21-13