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.

N174KBlueskies Aviation Services LLC · Charlestown, INBuilt 1968 · S/N 310N-0143 N174URocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N TH-73 N17526Preferred Land Solutions LLC · Belden, MSBuilt 1977 · S/N TC-2031 N175AMStevens Daniel · Oak Creek, COS/N 421C1221 N175SPN500aa LLC · Wilmington, DES/N 414A0313 N17625Oehler David W · Ponchatoula, LABuilt 1977 · S/N TC-2070 N17626Beaugrenelle Aero Inc · Wilmington, DEBuilt 1977 · S/N TC-2061 N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810 N1767WN1767w LLC · Dover, DEBuilt 1972 · S/N TC-1500 N1768MWyoming Valley Air LLC · Old Forge, PAS/N 33701368 N176BCCousins Mark T · Portland, ORS/N ME-269 N176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496427 N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511 N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045 N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046 N17790Tds Property Holdings LLC · Gilmer, TXBuilt 1977 · S/N TC-2055 N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241 N177FMeek Harvey K · Poplar Grove, ILBuilt 1964 · S/N TC-587 N177WWWallace William R · Fredericksburg, TXBuilt 1980 · S/N TC-2295 N17833Mccall Edmund B · Portland, ORBuilt 1977 · S/N TH-827 N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58 N1786MClark David A · San Jacinto, CABuilt 1971 · S/N 33701386 N178EGagan Samrat LLC · Charlotte, NCS/N 30-1727 N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028 N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028 N178SGTango Tango LLC · Naples, FLS/N 31T-8020044 N178UDavis Roger W · Felton, DEBuilt 1969 · S/N 30-1779 N178WDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N TC-2096 N178XSs Aviation LLC · Sulphur, LAS/N 30-1950 N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832 N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840 N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074 N17AFRolle Caraine A · Cypress, TXBuilt 1973 · S/N 27-7405291 N17AKFrancis Joseph · Kure Beach, NCBuilt 1978 · S/N 27-7854103 N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524 N17BDRegistered aircraftBuilt 1967 · S/N 30-1520 N17BPTeam Yak Attack Inc · Poplar Grove, ILBuilt 1974 · S/N TC-1650 N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372 N17CMAbernathy Laurence K · Wills Point, TXBuilt 1964 · S/N 30-437 N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488 N17FWhiteside Andrew A · Essexville, MIBuilt 1954 · S/N 23-119 N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210 N17HLRiley Charles S · Littleton, COS/N 421B-0310 N17KGJamey Johnson Inc · Fisher, LABuilt 1975 · S/N TC-1849 N17LCGilpin Kevin E Trustee · Weston, MABuilt 1972 · S/N TC-1474 N17MBAerocorp LLC · San Antonio, TXBuilt 1966 · S/N 30-1215 N17MHEcho Aviation LLC · Verona, WIS/N 340A0797 N17NWEye Clinic Building Lllp · Bismarck, NDBuilt 1979 · S/N 414A0223 N17PSNorris C · Land O Lakes, FLBuilt 1976 · S/N 31P-7630008 N17QYQuebec Yankee LLC · Tucson, AZBuilt 1981 · S/N 348133117

Back to AD 2004-25-16 R1