OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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-25-16-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-25-16-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.

N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347N613WCAmpaire Inc · Hawthorne, CABuilt 1966 · S/N 337-0372N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344N6140NMurray Edward K · Fallbrook, CABuilt 1981 · S/N TC-2428N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353N6145JGoodman Aircraft Inc · Wilmington, DEBuilt 1982 · S/N TC-2429N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366N614BSPicton Jerry Francis · Rockport, TXBuilt 1975 · S/N TC-1917N614DPInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 447995119N614JDCc Aviation Inc · Tracy, CABuilt 1967 · S/N 30-1517N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136N614RSecker David · San Jose, CAFirst renewal noticeBuilt 1964 · S/N 30-658N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006N615ABBolea Air Inc · Morgan Hill, CABuilt 1964 · S/N TC-815N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317N616BBHarp Air LLC · Lowell, MIBuilt 1978 · S/N 34-7870288N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375N616STK&S Flights LLC · Sweet Valley, PABuilt 1981 · S/N 414A0806N616UACole Thomas Ed · White Settlement, TXS/N TC-1039N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391N6175ATiffin Aire Inc · Tiffin, OHBuilt 1979 · S/N 31T-7920011N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897N617PTSmart Motion Aviation LLC · Frisco, TXBuilt 1979 · S/N TH-1043N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034N6188MDanze Alex · Riverside, CABuilt 1982 · S/N TH-1318N6189YSmith Brian Charles Jr · Lake Mary, FLBuilt 1966 · S/N 27-3415N618MROshaughnessy Stephen M · Littleton, COBuilt 1979 · S/N 340A0653N6190UCox Paul G · Bryce, UTBuilt 1974 · S/N 31-7401232N6193QRedstar Air Shows Inc · Discovery Bay, CAFirst renewal noticeBuilt 1968 · S/N 320F-0043N6193YMatthews Aviation LLC · Hardinsburg, KYBuilt 1966 · S/N 27-3419N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045N6198HLane Aviation Inc · Rosenberg, TXS/N 25-5419N6199XH&S Aviation LLC · Chesapeake, VABuilt 1982 · S/N ME-437N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336N619BLPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554003N619DCHarvard Air Taxi LLC · Andover, MABuilt 1979 · S/N 34-7970495N619PREm Concordia Inc · Brooklyn, NYS/N 31-8052061N61ABj Aviation LLC · Beaver Meadows, PABuilt 1968 · S/N 337-0886
Back to AD 2004-25-16 R1