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.

N5925VMcgreevy Duane T · Spearfish, SDBuilt 1977 · S/N 34-7770271 N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152 N592NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496634 N5930YHopkins Frank Michael · Wilmington, DEBuilt 1965 · S/N 27-3091 N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071 N59327Smith Steve W · Mackay, IDBuilt 1966 · S/N 337-0373 N5933MMonahan Robert J · Bulverde, TXBuilt 1969 · S/N 310P0233 N5934M34m LLC · Young Harris, GABuilt 1969 · S/N 310P0234 N5938MKarlen John R · Boring, ORS/N 340-0074 N5938YFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 27-3103 N593NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496270 N593RAMakonnen Iyob · Atlanta, GABuilt 1981 · S/N TH-1307 N593RGAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 3447022 N593TCGarmin International Inc · Olathe, KSBuilt 2015 · S/N 20800576 N5948YFbm LLC · Laporte, INS/N 27-3114 N5949MSnflk Leasing LLC · Andrews, TXBuilt 1972 · S/N 421B0319 N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440 N594DSJsb Aviation LLC · Harrison, ARBuilt 1980 · S/N TJ-318 N594WBUintacor Inc · Mesa, AZS/N 310Q0077 N5951MMcdonnell Enterprises Inc · Wilmington, DEBuilt 1973 · S/N 310Q0737 N5955MMonte'S Flying Circus LLC · Wonder Lake, ILS/N 27-3979 N595CCarol Corp · Lincoln, NES/N TC-863 N595NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496271 N595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeBuilt 1979 · S/N TJ-189 N5961YWillis Burlin T · Wasilla, AKBuilt 1965 · S/N 27-3130 N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205 N5963YS And S Aviation Consulting · Hampshire, ILBuilt 1966 · S/N 27-3132 N5967MN5967m LLC · Chantilly, VAS/N 421B0210 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N596NDSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2009 · S/N 4496272 N5972YBm Aviation LLC · Vinton, VABuilt 1966 · S/N 27-3143 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010 N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028 N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037 N59777Sofisa Airways Corp · Coral Gables, FLBuilt 1976 · S/N 31-7612020 N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148 N5979FFly By Knight Inc · Hammond, LABuilt 1976 · S/N 34-7770029 N597LDewitt Troy C · Lake Elmo, MNS/N 30-575 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N5986YBlackhawk Holding Corp · Wilmington, DEBuilt 1966 · S/N 27-3159 N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231 N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003 N598NDBremfour Aviation Group Inc · Wilmington, DEBuilt 2010 · S/N 4496282 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027

Back to AD 2004-25-16 R1