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.

N10990Speed And Angels LLC · Dover, DEBuilt 1971 · S/N 329-72 N1099AFritz William · Franklin, PABuilt 1997 · S/N E-3088 N1099CBrooks Jerald W · Anderson, CABuilt 1959 · S/N 1370 N1099FSaal Christopher J · Anchorage, AKFirst renewal noticeBuilt 1975 · S/N 18502754 N1099MSavery Creek Holdings LLC · Dixon, WYS/N EA-591 N1099WTop Hand Inc · Laurel, MTBuilt 1973 · S/N E-424 N109AALiberty Aviation LLC · Brighton, COBuilt 2007 · S/N 2427 N109AFD&D Aviation LLC · Weatherford, TXBuilt 1981 · S/N CE-983 N109AMRussell Construction · Douglas, WYBuilt 2000 · S/N 1464 N109BRotorwing LLC · Walnut, ILBuilt 2007 · S/N 1743 N109BABall Edward C II · Valley Center, CABuilt 1992 · S/N CE-1658 N109BJIssg Inc · Waynesville, OHBuilt 2014 · S/N 72946 N109BLGraber Raymond B II · Carson City, NVBuilt 1992 · S/N 3274 N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533 N109CQWatkins Eric Brian · San Diego, CABuilt 2016 · S/N 18282462 N109DMNance David · Cross Roads, TXBuilt 1997 · S/N MAN-1 N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13 N109EADegiarde Robert P · New York, NYBuilt 1994 · S/N E-2897 N109EHSwatosh James K · Stillwater, MNBuilt 1989 · S/N 038 N109FRWilson Ronald Earl · Sedona, AZBuilt 1981 · S/N 17275192 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921 N109HJStk Construction And Development Inc · Temecula, CABuilt 2006 · S/N 90296 N109JGGraham Field Ltd · Adams Mills, OHBuilt 2004 · S/N 459-2004 N109JHRoeloffs Arie · Wendell, IDBuilt 1997 · S/N 808 N109JLFouts Benjamin Cody · Kailua Kona, HIBuilt 1989 · S/N 3109 N109LASullivan Bradley · Tomball, TXS/N 398 N109LLLewis & Lewis Equipment LLC · Dodge City, KSBuilt 1991 · S/N E-2626 N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991 N109MCPrater Grant · La Vernia, TXBuilt 2006 · S/N 11342 N109MLJerry Luttrell And Associates Inc · Kearney, MOBuilt 1988 · S/N E-2450 N109MYYonchak Mark A · Alexandria, VABuilt 2021 · S/N 2000 N109PCFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2005 · S/N 994-2005 N109PSStanley Patrick L · League City, TXBuilt 1988 · S/N M-1-623 N109QShariff Diane · Cameron Park, CABuilt 1966 · S/N D-8126 N109RBClark William R · Anchorage, AKBuilt 1965 · S/N 282612 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N109RDValiair Lc Trustee · Casper, WYBuilt 1996 · S/N 001-P N109RJBraunschmidt Robert J · Lennox, SDBuilt 2005 · S/N 90201 N109RVLuck Richard S · Superior, WIBuilt 2002 · S/N 90355 N109SGreenair Corp · Memphis, TNBuilt 1958 · S/N TD-140 N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799 N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985 N109UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1214 N109VKeeling Rodney E · Pearce, AZBuilt 1960 · S/N CD-160 N109WBurnett Wade · Sandpoint, IDBuilt 2022 · S/N SC-18-187 N109WCCarpenter Wayne E · Mount Vernon, WABuilt 1992 · S/N 109 N109WWThiel Daniel R · Cheyenne, WYBuilt 2006 · S/N 2368 N109WYPerala Daniel R · Cheyenne, WYBuilt 1969 · S/N 18260131 N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513

Back to AD 2007-04-19 R1