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.

N22PWGoldsboro Flight Club LLC · Faison, NCBuilt 1975 · S/N 34-7570144 N22SBRamsey Timothy · Saraland, ALBuilt 1966 · S/N 310K0087 N22SGAir Flight Enterprises Inc · South Daytona, FLS/N 30-1718 N22TYCygnus9 LLC · Fayetteville, NCBuilt 1997 · S/N TH-1826 N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074 N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171 N22WFBemidji Aviation Services Inc · Bemidji, MNBuilt 1978 · S/N 31T-7920007 N22WPMatulich Ronald G · Drytown, CABuilt 1967 · S/N TC-1045 N22ZZTreicher Peter · East Aurora, NYFirst renewal noticeBuilt 1979 · S/N 27-7954043 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011 N230MJVne LLC · Sheridan, WYS/N 30-1302 N230MWGot Wings LLC · Woodbury, NYS/N 421C0671 N230SUBoelte Aviation LLC · Wilmington, DEBuilt 2026 · S/N 4496639 N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37 N230UBoard Of Regents · Norman, OKBuilt 2024 · S/N 4496587 N2313ZT R Gemelli Holding Co LLC · Wilmington, DEBuilt 1979 · S/N 27-8054013 N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628 N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696 N231WEJones Jason Bart · Frankfort, ILBuilt 1980 · S/N TJ-263 N231WURegistered aircraftBuilt 2006 · S/N 4496231 N2320AStructural Integrity Systems LLC · Wichita, KSBuilt 1977 · S/N TC-2113 N2320MAkl Properties · Westlake, OHBuilt 1979 · S/N 27-7954038 N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039 N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232 N232RSWright Aviation LLC · Lawton, OKBuilt 1974 · S/N 310Q1145 N232WAFremont Motors Rocksprings Inc · Rawlins, WYBuilt 1981 · S/N 34-8233020 N2332SLouisiana Military Museum · Abbeville, LAS/N 337-0632 N2333BN2333b LLC · Oklahoma City, OKBuilt 1997 · S/N TH-1833 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835 N233CTHoneycutt Danny · Angier, NCBuilt 1984 · S/N TH-1433 N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009 N233PSDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7820039 N2344SAnderas Per R · Green Bay, WIBuilt 1967 · S/N 337-0644 N2345AAeolus Gold LLC · Wilmington, DEBuilt 1974 · S/N 421B0636 N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019 N2345SSummers Jeffrey L · Pekin, INBuilt 1967 · S/N 337-0645 N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867 N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209 N234ATr Aero LLC · Poway, CABuilt 1972 · S/N TC-1437 N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909 N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203 N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122 N234FYVee Two Inc · Merritt Island, FLBuilt 1978 · S/N 347870428 N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234MWKuehn Kevin C · De Pere, WIBuilt 1964 · S/N 310I0034 N234NCIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350146 N234PLCole Steven David · Saint Petersburg, FLS/N 31P-7300147 N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368

Back to AD 2004-25-16 R1