Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211 N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335 N3811XBaron 55 LLC · Hanover, NHBuilt 1981 · S/N TC-2368 N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390 N3812XJets And Props Corp · Reno, NVS/N 310K0212 N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213 N3815EHonest Dog Farms LLC · Fayetteville, GABuilt 1966 · S/N 30-1335 N38166S&P Airplane Sales · Branson West, MOBuilt 1981 · S/N TC-2371 N38173Tingley Robert D · Watham, MABuilt 1977 · S/N 34-7770289 N3817XPeterson Randall J · Lake Havasu City, AZBuilt 1966 · S/N 310K0217 N3818XAcme Racing LLC · Overland Park, KSBuilt 1966 · S/N 310K0218 N38198Zero Mike LLC · Chattanooga, TNBuilt 1981 · S/N TC-2387 N3819XBoerne Flight Options LLC · Boerne, TXBuilt 1966 · S/N 310K0219 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341 N3820MIsrael Howard A · Santa Monica, CABuilt 1981 · S/N TC-2372 N3820XDwyhalo David W · Moorpark, CABuilt 1966 · S/N 310K0220 N3823XRegistration Pending · Logan, UTRegistration pendingBuilt 1966 · S/N 310K0223 N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N3828XAmerican Flightscope Inc · Wilmington, DEBuilt 1981 · S/N TC-2374 N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711 N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096 N382MCShiver James B · Stanley, NMS/N 421B0452 N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388 N3834ZImmen David F · Bonanza, ORBuilt 1978 · S/N 34-7870225 N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671 N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395 N3838XHolzman Douglas S · Hood River, ORBuilt 1966 · S/N 310K0238 N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397 N3839XMigliaccio Vicki Trustee · Idabel, OKBuilt 1966 · S/N 310K0239 N3841XJ W Faherty Inc · Apple Valley, CABuilt 1966 · S/N 310K0241 N3843SSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N TK-139 N38455Krenitsky Harrison J · Poland, OHBuilt 1977 · S/N 34-7770306 N3845LDonq LLC · Hartford, CTBuilt 1981 · S/N TC-2378 N3845XHaas James D · Frisco, TXBuilt 1966 · S/N 310K0245 N3848YBaron Lake LLC · Jefferson, LABuilt 1981 · S/N TJ-349 N384AMHaggard Haley G · Springer, OKS/N 421B0304 N3850GN3850g LLC · Stamford, CTBuilt 1976 · S/N 340A0208 N38570Dm Asset Management LLC · Plain City, OHBuilt 1981 · S/N TC-2381 N385ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 2095 N385RMG Force Air LLC · Columbus, OHBuilt 1978 · S/N 31-7852125 N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130 N3860VAts LLC · Memphis, TNBuilt 1981 · S/N TC-2382 N38625Smith Mark S · Cornville, AZBuilt 1977 · S/N 34-7770329 N3864UInterrail Power Inc · Jacksonville, FLBuilt 1981 · S/N TJ-355 N38679Bwt Aviation LLC · Montgomery, ALBuilt 1977 · S/N 34-7770332 N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251 N3869YMak Air Ventures LLC · Smithfield, NCBuilt 1981 · S/N TC-2388 N386ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 2093 N386AVWestwind School Of Aeronautics Phoenix · Goodyear, AZBuilt 2025 · S/N 4496614

Back to AD 2004-25-16 R1