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.

N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172 N1920CVanjara Gufran U · San Ramon, CABuilt 1964 · S/N 2686 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1920FChristensen Dean G · Elk Grove, CABuilt 1979 · S/N 17273012 N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792 N1920MThompson William F · Fisherville, KYBuilt 1975 · S/N 18264482 N1920QAcadian Aircraft Leasing LLC · Rangeley, MEBuilt 1977 · S/N 18503502 N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579 N1920XJensen Richard Vaughn · Emmett, IDBuilt 1965 · S/N 18256020 N1921Koons Zachary K · Clinton, ILBuilt 1993 · S/N 20580 N1921FState Of Iowa · Iowa City, IABuilt 1979 · S/N 17273013 N1921MRed Shirt Resources LLC · Weatherford, TXBuilt 1975 · S/N 18264483 N1922LGassi Vito · Levittown, NYBuilt 1976 · S/N M-1819 N1922PNey N Marshall · Kapaau, HIS/N 22-2673 N1922TBiscoe Donald M · Cottage Grove, MNBuilt 1969 · S/N 21059220 N1922UFriedrich Richard R · Newtown, CTS/N 185-1593 N1922VRogers Randall J · Newalla, OKBuilt 1974 · S/N 17263796 N1922XHerman Joseph T · Lovell, WYBuilt 1965 · S/N 18256022 N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217 N19234Sharkey William Patrick · Walla Walla, WABuilt 1976 · S/N 17702563 N1923FAtlanta Air Academy LLC · Kennesaw, GABuilt 1980 · S/N 17273015 N1923HGardner Christopher M · Mankato, MNBuilt 1977 · S/N 28-7725168 N1923RUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 1217-2024 N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218 N19245Immel Justin Harrison · Minonk, ILBuilt 1976 · S/N 17702564 N1924HSkyjiro Forge Corp · Arcadia, CABuilt 1977 · S/N 28-7725169 N1924YHull Thomas · Midland, TXS/N 219 N1925XBtak LLC · New Baden, ILBuilt 1965 · S/N 18256025 N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220 N1926FUnited Flying Club Inc · Belmont, CABuilt 1979 · S/N 17273017 N1926PHoudek Dennis E · Roseburg, ORBuilt 1955 · S/N 22-2677 N1926QVonimhof Rudolph F · Anchorage, AKBuilt 1977 · S/N 18503503 N1926REmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2025 · S/N 172S13436 N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287 N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587 N1926XWilkerson Kelvin E Jr · Kannapolis, NCBuilt 1965 · S/N 18256026 N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221 N19274Jennings Lisa Nicole · Atlanta, GABuilt 1976 · S/N 17702566 N1927FSanders Herman G · Baldwyn, MSBuilt 1979 · S/N 17273018 N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017 N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796 N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857 N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609 N1928FJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17273019 N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533 N1928YMaddex William E · Battle Ground, WAS/N 235 N1929LIngstad Eric Charles · Lakewood, CABuilt 1976 · S/N MC-416 N1929UHolmgren David J · Plainfield, NJBuilt 1962 · S/N CD-554 N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964 N192ACByrd Ronald D · Farwell, TXBuilt 1994 · S/N 1203-95

Back to AD 2007-04-19 R1