AD 2002-07-01

Registered aircraft · 3,466

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-07-01')
    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-07-01')
  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.

N5799JBritt Demolition And Recycling Inc · Hanceville, ALBuilt 1971 · S/N 21059499N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564N5821FFlite Five Inc · Kiowa, KSBuilt 1966 · S/N 21058821N5822FGrein David A · Mokena, ILS/N 21058822N5827FBok Hans · North Dartmouth, MABuilt 1966 · S/N 21058827N5828FKissell Ryan · Mount Vernon, OHBuilt 1966 · S/N 21058828N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609N58502H E Fly Float LLC · Virginia Beach, VABuilt 1974 · S/N U20602618N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864N5867FIndigo Of South Fl Inc · Sunrise, FLS/N 21058867N5869FCavanaugh Gerald R · Friendswood, TXBuilt 1967 · S/N 21058869N5872FStearns Edwin B Jr · Chandler, AZBuilt 1967 · S/N 21058872N5873FWehrman George · Covina, CABuilt 1967 · S/N 21058873N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887N5888CCwf Enterprises Inc · Grove, OKS/N U20605888N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384N58BDBravan Aviation Inc · Fort Lauderdale, FLS/N 21062742N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920N58MARagan Edwin E III · Austin, TXBuilt 1977 · S/N 21062237N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018N5902FPeters Kenneth R · Plainfield, ILBuilt 1967 · S/N 21058902N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049N5904FRegistered aircraftBuilt 1967 · S/N 21058904N59060Agriflite Services Inc · Wakarusa, INBuilt 1973 · S/N 21060059N59073Hartenstine Michael Carl · Lancaster, CABuilt 1973 · S/N 21060069N5907FIsland City Seaplanes Inc · Cordova, AKBuilt 1967 · S/N 21058907N5908FCharger Aviation LLC · Chariton, IABuilt 1967 · S/N 21058908N5909FHendrix Benton · Eckley, COBuilt 1967 · S/N 21058909N59105Allen Willis M Jr · El Cajon, CABuilt 1973 · S/N 21060093N59141Peters Mark E · Newport News, VABuilt 1973 · S/N 21060118N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916
Back to AD 2002-07-01