OpenAirDocs.org
AD 2004-21-08 R1

Registered aircraft · 511

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

N4487CBaldeo Kessho I · Bay Shore, NYBuilt 1953 · S/N 16071N4488CNix Terry W · Golden, MSBuilt 1953 · S/N 16072N4489CInabnit Shon G · Colville, WAS/N 16073N4492CYates Daniel A · Saint Louis, MOBuilt 1953 · S/N 16076N4494CWest Thomas P · Bridgeport, OHBuilt 1953 · S/N 16078N4495CAustin Cody · Pflugerville, TXS/N 16079N4498CGoettl Karl T · Clarkdale, AZBuilt 1953 · S/N 16082N450RETurrell James A · Flagstaff, AZBuilt 1953 · S/N 7586N460AHensley Scott · Elbert, COS/N 7553N4707VWhite Timothy C · Grapevine, TXS/N 7275N4745GMorris Thomas B · Imlay City, MIBuilt 1948 · S/N 7173N47KLSee David M · Shady Shores, TXBuilt 1947 · S/N 7053N4929CBerry Darrel · Camden, TNBuilt 1959 · S/N 7803N515BFDelaware Aviation LLC · Sidney, NYBuilt 1950 · S/N 7526N55MStevens Donald K · Canton, GABuilt 1949 · S/N 7408N56WKarpik Joseph P · Floodwood, MNBuilt 1952 · S/N 7952N597KKriedeman Daniel Paul · Port Orange, FLBuilt 1949 · S/N 7403N5NHower James A · Horseshoe Bay, TXBuilt 1949 · S/N 7356N60QMcleod Cecil H · Mt Pleasant, SCBuilt 1954 · S/N 16131N60WRadisch Herbert R Jr · San Diego, CABuilt 1949 · S/N 7385N6492DVessey Benjamin S · Fort Collins, COBuilt 1959 · S/N 7383N6577DScootair LLC · Alburgh, VTS/N 7847N6857DDynamic Aerospace Inc · Framingham, MABuilt 1951 · S/N 7848N6889DBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7846N6896CCurry Caleb C · Edmond, OKS/N 7340N689THBig Squirrelly LLC · Kalispell, MTBuilt 1947 · S/N 7025N714EGajewski Lillia M · Billings, MTBuilt 1947 · S/N 7271N72CCasa Acquisitions LLC · Winter Haven, FLBuilt 1948 · S/N 7219N7422XMacvey Troy R · Milan, INBuilt 1949 · S/N 7422N754BMPitot Heat Inc · Huntington, NYBuilt 1952 · S/N 7875N775AVintage Air LLC · Brighton, MIBuilt 1951 · S/N 7631N775RCummins Michael · Corona, CAS/N 7478N829TJJ T Airshows · Slidell, TXBuilt 1953 · S/N 16048N841DPSior David · Connelly, NYBuilt 1953 · S/N 16112N87EFCaldera Efrain · West Milford, NJBuilt 1950 · S/N 7482N8860NBroussard Lewis A Jr · Morse, LABuilt 1948 · S/N 7232N88DLLight Equipment Service LLC · Sunset, LABuilt 1959 · S/N 7935N9054ZAeronautical Educational Foundation · Stockton, CABuilt 1951 · S/N 7819N9303AYaw David Oderkirk Trustee · El Dorado Hills, CABuilt 1949 · S/N 7382N9312ARudisel Kenneth J · Williamsburg, MIBuilt 1949 · S/N 7367N9317ACunningham Kenneth R · Lawton, OKBuilt 1949 · S/N 7396N9318ASmith Michael Todd · Edgerton, MOBuilt 1949 · S/N 7397N9319AMyers Alan J · Danville, ILBuilt 1949 · S/N 7398N9322ALeamon Douglas H Trustee · Stockwell, INBuilt 1949 · S/N 7401N9324ABoswell Kurt R · Renton, WAS/N 7636N9325ABarron Aviation LLC · Perry, MOS/N 7404N9330ACrh LLC · Middlebury, CTBuilt 1949 · S/N 7409N9334AHusser Leonard A · Camano Island, WABuilt 1949 · S/N 7413N9337AStich Michael T · Malvern, OHBuilt 1949 · S/N 7416N9338APeck Darren K · Noblesville, INBuilt 1949 · S/N 7418
Back to AD 2004-21-08 R1