Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N13286Aero Club Seven Inc · Crosslake, MNBuilt 1973 · S/N 17262640 N13287Armstrong Aviation Services LLC · Freeport, PABuilt 1973 · S/N 17262641 N1328ESj28e LLC · Durango, COBuilt 1978 · S/N 17270958 N1328JO'Brien Patrick J · Santa Paula, CABuilt 1976 · S/N 13038 N1328RTrout Fred C · Dallas, GABuilt 1974 · S/N AA5-0728 N1328SScott Adrienne Diann · College Station, TXBuilt 1976 · S/N 18264892 N1328UMetildi Frederic H · Penfield, NYBuilt 1976 · S/N 17267016 N1328ZStewart Ian D · Beaverton, ORBuilt 1961 · S/N D-6761 N13293Atp Aircraft 2 LLC · Wilmington, DEBuilt 1973 · S/N 17262644 N13294Cmb Aviation Inc · Surf City, NCBuilt 1973 · S/N 17262645 N13295Johnson Thomas C Jr · Adrian, MIBuilt 1973 · S/N 17262646 N13296T31 Fliers LLC · Prosper, TXBuilt 1973 · S/N 17262647 N13297Sale Reported · Lakeview, ORSale reportedBuilt 1980 · S/N 18053167 N1329CHughes Steve D · Ellsworth, WIBuilt 1953 · S/N 22-1119 N1329PN1705r Inc · Cobb, CAS/N 23-373 N1329QGodlove Gary L · Glendale, AZBuilt 1973 · S/N 17262642 N1329RDeltondo Ralph P · Fullerton, CAS/N AA5-0729 N1329TPiper Electric Inc · Deer Park, NYBuilt 2024 · S/N 14753 N1329UA C W Inc · Gonzales, LABuilt 1982 · S/N 21064687 N1329WKasowski Frank Jr · Becker, MNBuilt 1963 · S/N 217 N1329ZNoble Mitchell S · Carleton, MIBuilt 1961 · S/N CD-354 N132ABScenix Air LLC · Batavia, OHBuilt 1974 · S/N 1004 N132ACScott John A · Odebolt, IABuilt 1992 · S/N 675-92 N132AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496590 N132AMTemple James C · Lincoln, CABuilt 1978 · S/N 28-7990245 N132BMds Flying LLC · Deephaven, MNBuilt 1981 · S/N TE-1189 N132BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843583 N132BGN132bg Corp Trustee · Wilmington, DEBuilt 2005 · S/N 29-0398 N132BUPatrick Sharon K · Thomasville, GABuilt 1954 · S/N 437 N132CTausch Roger M · Saint Charles, MIBuilt 1963 · S/N 30-62 N132CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881354 N132CLMalecha Curtis E · Fergus Falls, MNBuilt 2011 · S/N 019-020-030-672 N132CMWells Garry L · Scotia, NEBuilt 2002 · S/N 2207 N132DMWilliams Robin M · Belgrade, MTBuilt 1975 · S/N 18052628 N132DPKarl Mark G · Wilbraham, MABuilt 1999 · S/N 822-99 N132DWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496139 N132FPendergrass Glen · Plainview, TXBuilt 1964 · S/N 4104 N132FBRock Rivers Bancorp · Rock Rapids, IABuilt 1975 · S/N E-700 N132FLShaw Jimmy D · Springfield, NEBuilt 1985 · S/N 632 N132GAHolt Drew R · Lake Jackson, TXS/N 2086 N132HMMichels Agribusiness Inc · Plentywood, MTBuilt 1978 · S/N R18200844 N132HYCummings Drew T · Lewistown, MTBuilt 2001 · S/N 2132 N132JFFoster Aaron · Windermere, FLBuilt 1999 · S/N 5080 N132JPNames Loch K · Eugene, ORBuilt 1985 · S/N 001-JP N132LESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-40038 N132MABarry Casey B · Wichita Falls, TXBuilt 2001 · S/N 30-0060 N132MEPena Jairo · Catharpin, VABuilt 2000 · S/N 18280690 N132MHUtah State University · Logan, UTBuilt 2004 · S/N 3648 N132MRReese Jeffrey D · Portland, ORBuilt 1950 · S/N 18-209 N132MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496540

Back to AD 2007-04-19 R1