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.

N844CKTurpin Time LLC · Helena, MTBuilt 1979 · S/N 421C0706 N844MECti Aircraft Leasing LLC · Memphis, TNBuilt 2020 · S/N 4496497 N8452YRhodes Cleo B · Dayton, VABuilt 1967 · S/N 30-1611 N8453XOtto Joel C · Lander, WYBuilt 1981 · S/N 44-8107066 N8455ZD&J Aviation LLC · Apopka, FLBuilt 1981 · S/N 34-8233003 N8456CAmblygon Ltd Co · Boise, IDBuilt 1981 · S/N 34-8233008 N8456HWings Of Hope Inc · Chesterfield, MOBuilt 1981 · S/N 34-8233011 N8456NBowling Green Aviation LLC · Germantown, TNBuilt 1968 · S/N TC-1103 N8456YCfl Aircraft Sales LLC · Tampa, FLBuilt 1967 · S/N 30-1615 N8458YOakes Michael J · Walnut Creek, CABuilt 1967 · S/N 30-1617 N845BWOcean Palms Aviation LLC · Hudson, FLS/N 34-7870279 N845LMarshall Timothy Trustee · Tucson, AZBuilt 1982 · S/N 340A1511 N845YCFruscella Alfredo J · Tampa, FLBuilt 1973 · S/N 421B0351 N8460ASpurgeon William E Trustee · Edmond, OKBuilt 1981 · S/N 34-8233019 N8461HTwin Seneca 8461h LLC · Lewes, DEBuilt 1981 · S/N 34-8233024 N8464PPerma-Cal Leasing Inc · Minden, NVBuilt 1981 · S/N 34-8233031 N8465BLalaguna Ricardo · Orlando, FLS/N 44-8207003 N8468JKrantz John · Springfield, TNBuilt 1981 · S/N 34-8233039 N8468YStone D L · Arlington, TXBuilt 1967 · S/N 30-1629 N846JWPrater Keith · Blaine, WABuilt 1975 · S/N 34-7670080 N847Ultimate Resort Vacations Inc · Weston, FLBuilt 1977 · S/N 31-7812020 N8472BTmstarservices LLC · Lewes, DEBuilt 1981 · S/N 34-8233042 N8475YSolymossy Robert A · Tysons, VABuilt 1967 · S/N 30-1637 N847BRegistration Inc · Kalispell, MTS/N 30-348 N847EDFoster Matthew R · Poplar Grove, ILBuilt 1968 · S/N 30-1692 N847NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496474 N8486ZKlompstra John V · Wadsworth, OHBuilt 1963 · S/N 30-227 N8487FFuhr David · Wabasso, MNBuilt 1976 · S/N 34-7770087 N8487YAviation Safety Dynamics LLC · Richmond, TXBuilt 1967 · S/N 30-1650 N8489FRegistration Pending · San Diego, CARegistration pendingBuilt 1976 · S/N 34-7770088 N8489YSorbi Aviation Inc · El Cajon, CABuilt 1967 · S/N 30-1652 N8492YGaipa Timothy A · Saint Joseph, MIBuilt 1967 · S/N 30-1655 N8493NSoderblom Edward J · Ferndale, WABuilt 1968 · S/N TC-1112 N8494NLemons Hayden · Conway, ARS/N TC-1113 N8496NIsaacs Brandon · Homedale, IDS/N TC-1115 N8496YOsiol Russell E · Chicago, ILS/N 30-1297 N849ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496567 N849DWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 317952070 N849JBDodson International Parts Inc · Rantoul, KSS/N 421A0075 N84BDWhite Birch Transportation · Lee, NHBuilt 2002 · S/N 20800353 N84CGGuardian Angel Homes LLC · Hayden, IDBuilt 1981 · S/N 340A1274 N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519 N84HCJeffcoat Roy B · Anderson, SCBuilt 1976 · S/N 340A0052 N84JBPremise Aviation LLC · Elizabeth, COS/N 340A1009 N84JSKocak Robert G Jr · Peoria, AZBuilt 1966 · S/N 30-1222 N84PECarosso Kevin V · Santa Cruz, CABuilt 1984 · S/N TJ-470 N84PRSkov Equipment Co · Fabens, TXBuilt 1979 · S/N 414A0213 N84RTChannell Robert D · Moreland, GABuilt 1973 · S/N 421B0355 N84TAAnderson Wallace A · Melbourne, FLBuilt 1974 · S/N TC-1769 N84TDBailey Dennis · Kernersville, NCBuilt 1969 · S/N 30-1951

Back to AD 2004-25-16 R1