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.

N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22 N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24 N886ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496323 N886BATerzo Richard E · Lake Zurich, ILBuilt 1981 · S/N 340A1269 N886FTChristiansen Aviation LLC · Wilmington, DES/N 4496349 N8876YComanche 76y LLC · Waynesboro, VAS/N 39-32 N8877YVanhook Orville Richard · Somerset, KYBuilt 1970 · S/N 39-34 N887ACBrg Enterprises LLC · Johns Island, SCS/N TH-603 N887JBBertrand Carolyn L · Ridgecrest, CABuilt 1966 · S/N 337-0559 N887PMHarris William M · Radford, VABuilt 1970 · S/N 39-25 N8880YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-38 N8883YYank N Bank LLC · Greeley, COBuilt 1970 · S/N 39-41 N8884YFlight Logistics LLC · Westerville, OHS/N 39-46 N8885YWilson Cecil · Lithonia, GABuilt 1970 · S/N 39-43 N888BAmerican Airpower Museum · Farmingdale, NYBuilt 1967 · S/N 3370586 N888BGOgden Thomas C · New Cumberland, WVBuilt 1973 · S/N 33701508 N888BPXyz1234 LLC · Addison, TXBuilt 1979 · S/N 340A0737 N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421 N888EWWilmes Window Mfg Co Inc · Santa Claus, INS/N 34-8170027 N888HCGolden Eagle 888hc LLC · Durham, CABuilt 1975 · S/N 421B0821 N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078 N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272 N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464 N888MTSpelts Mark Warren Trustee · Chico, CABuilt 1979 · S/N 340A0763 N888NNorman James R · San Diego, CABuilt 1973 · S/N 340-0312 N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086 N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066 N888RCLeahy Kyle Bergen · Dallas, TXS/N 310I0067 N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139 N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032 N888VFLiaboe Mark Osborne · Dubuque, IAS/N 34-8233073 N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550 N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561 N888YAAds-B Technologies LLC · Anchorage, AKS/N 31-7305076 N8891YGreat Plains Aero Inc · Iowa City, IABuilt 1970 · S/N 39-49 N8895YRegistered aircraftS/N 39-52 N8897YAvion LLC · Lewes, DEBuilt 1970 · S/N 39-54 N8898YWickenheiser Kenneth W · Sun City, AZBuilt 1970 · S/N 39-33 N889FTMolly Willis Ventures LLC · Albany, GABuilt 1997 · S/N TH-1828 N889NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496602 N889TSQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N TJ281 N88APLangdon Brian B · Newcastle, WABuilt 1964 · S/N 30-456 N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618 N88JBJr Aviation LLC · Benton, KSBuilt 1969 · S/N 310P0174 N88JTKimberlin Mark · Indio, CABuilt 1974 · S/N TC-1753 N88KAStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1972 · S/N 34-7350029 N88KGSky West Aviation Inc Trustee · Albuquerque, NMS/N 340-0510 N88KJLegal Air LLC · Charleston, WVS/N 31-7912077 N88LTRyan M Kearbey Dental Corp · Oroville, CABuilt 1973 · S/N 310Q0835 N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006

Back to AD 2004-25-16 R1