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.

N195PDDougherty Paul D Jr · Bethel, PABuilt 1950 · S/N 7460N195PKKourtis Vintage Aviation LLC · Owasso, OKBuilt 1951 · S/N 7712N195PLPerkins Terence R · Ormond Beach, FLBuilt 1948 · S/N 7262N195PRRg Aviation Inc · Wilmington, DEBuilt 1952 · S/N 7871N195PWRieke Rhett · Bigfork, MTBuilt 1949 · S/N 7647N195QPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N 7743N195RAJaeb Gerald E · Yankeetown, FLS/N 16099N195RCDuke Kay L · Darrouzett, TXBuilt 1953 · S/N 16102N195RERamey Robert L · Rose Hill, KSBuilt 1952 · S/N 7934N195RJJeffries Ronald G · Manson, WAS/N 7899N195RKLinnane Cory E · Schaumburg, ILS/N 7393N195RSInternational Air Services Inc Trustee · Carson City, NVBuilt 1950 · S/N 7594N195RWWhite Michael D Trustee · Willow Springs, MOBuilt 1948 · S/N 7088N195SFreedom Leasing Ent Inc · Wilmington, DEBuilt 1952 · S/N 7924N195SBJones Caleb A · Sanger, TXBuilt 1952 · S/N 7911N195SCSmith William E · Highland, CABuilt 1949 · S/N 7402N195SELewis Leigh Wade · Rockledge, FLS/N 7857N195SMBarron Aviation LLC · Perry, MOBuilt 1949 · S/N 7806N195STFly4sport LLC · Kasilof, AKBuilt 1950 · S/N 7527N195TGGoodwin Pilar Z · Lancaster, CABuilt 1949 · S/N 7341N195TWHenkemeyer Joseph · Cave Creek, AZBuilt 1952 · S/N 7981N195UDowd Darin R · Frisco, TXBuilt 1951 · S/N 7705N195VOdom John C · Fredericksburg, TXBuilt 1950 · S/N 7471N195VFMcfarlane Claude L III · Fitchburg, WIBuilt 1948 · S/N 7268N195VHKoehn Shane · Scooba, MSBuilt 1949 · S/N 7549N195WGFisher Group LLC · Ashland City, TNBuilt 1952 · S/N 7926N195WHCarolina Aero Tech LLC · Hilton Head Island, SCS/N 7324N195WLRegistration Pending · Coldwater, MIRegistration pendingS/N 7620N195WSSaloga William A Trustee · Batavia, ILBuilt 1952 · S/N 7908N195WTRowe James D · Nome, AKBuilt 1954 · S/N 16128N195XBusinessliner 190 Express LLC · Rogers, MNBuilt 1949 · S/N 7464N195YYoung Kenneth D · La Verne, CABuilt 1951 · S/N 7629N1960CSenger Bruce D · Mount Solon, VABuilt 1952 · S/N 7919N1CZWarden Richard L · Canby, ORBuilt 1950 · S/N 7481N1LEKingsley Kiman J · Miller, MOBuilt 1951 · S/N 7729N1TBR S Rowe Enterprises Inc Sp · Wilmington, DES/N 7756N2100CScootair LLC · Alburgh, VTBuilt 1953 · S/N 16085N2103CAeromobile Inc · Hernando, MSBuilt 1953 · S/N 16088N2104CBenger Jeffrey S · Bozeman, MTBuilt 1953 · S/N 16089N2105CEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1953 · S/N 16090N2112CRenkel Christopher P · Westlake, OHBuilt 1953 · S/N 16097N2113CHuton Thomas Wessie · Sanger, TXBuilt 1953 · S/N 16098N2116CMilton William W · Amsterdam, NYS/N 16101N2118C140 Ventures LLC · Lewes, DEBuilt 1953 · S/N 16103N2120CQuilter Charles J II Trustee · Laguna Beach, CABuilt 1953 · S/N 16105N2122CIrwin Dennis R · San Diego, CABuilt 1953 · S/N 16107N2123CZeiner Ty R · Marion, KSBuilt 1953 · S/N 16108N2124CSutliff Larrie G · Briarcliff Manor, NYBuilt 1953 · S/N 16109N2125CFroes Jonathan · Avondale, AZS/N 16110N2134CQualitair LLC · MichelstatdtBuilt 1955 · S/N 16119
Back to AD 2004-21-08 R1