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.

N171MLBruey William P · Santa Monica, CABuilt 1998 · S/N 171 N171PBHarding Derrick S DBA · Adair, OKBuilt 1995 · S/N E2992 N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164 N171RACirrus Aviation Inc · Sarasota, FLBuilt 1999 · S/N 172S8237 N171RMMckinney Mark · Meadowview, VABuilt 1972 · S/N U20601938 N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092 N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558 N171SFStratusfire LLC · St Charles, ILBuilt 2005 · S/N 40.494 N171SHDriftless Helicopters LLC · Galena, ILBuilt 2007 · S/N 11678 N171SKHuddleston Edward · Oaktown, INBuilt 1980 · S/N 17273857 N171SPState Of Iowa - Iowa State Patrol · Des Moines, IABuilt 2007 · S/N 18281977 N171STDkg Motorized Conveyances Inc · Beaverton, ORBuilt 2000 · S/N 18280703 N171TGarrett Wayne · Guntersville, ALBuilt 2025 · S/N 527-2025 N171TBMaritime Aviation Security Team · Wilmington, NCBuilt 2002 · S/N 40045 N171TLHickey Timothy J · Montrose, IAS/N 721 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N171TPPropst Terry L · Festus, MOBuilt 2023 · S/N 92310 N171TWRsj Aviation LLC · Winston Salem, NCBuilt 1984 · S/N 32R-8413019 N171UNancy Unicorn LLC · Seattle, WABuilt 1982 · S/N 18268147 N171VAEckles Aircraft LLC · Holdenville, OKBuilt 1979 · S/N 17272239 N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142 N171WAKessenich Kimberly D · Montello, WIBuilt 1973 · S/N 287305592 N171WBYeager Hal J · Winterset, IABuilt 1975 · S/N 18264036 N171WCRegistration Pending · Flora, ILRegistration pendingBuilt 1997 · S/N 0331 N171WRMcclaskey Samantha L · Wheatland, CAS/N 84197 N171WTB&B Aero LLC · Arlington, MABuilt 2009 · S/N 2064 N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857 N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467 N172Kirk James H Jr · Leavenworth, KSBuilt 1976 · S/N 762 N17204Estes Bruce E · Granite Bay, CABuilt 1976 · S/N 17702518 N1720A1720a LLC · Bethany, OKBuilt 2022 · S/N 172S12892 N1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationBuilt 1962 · S/N D-6943 N1720TLumi Wings Corp · Goodyear, AZBuilt 1970 · S/N 28-7125033 N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742 N1720ZBend Aircraft Mechanics LLC · Bend, ORBuilt 1977 · S/N 17269397 N1721Qualitair LLC Trustee · MichelstadtBuilt 1993 · S/N E-2783 N17219Daniel Boone Flying Club Inc · Boonville, MOBuilt 1976 · S/N 17702519 N1721CLemons Air LLC · Boulder, COS/N 30421 N1721GCorlett Samuel E · Fort Worth, TXBuilt 1962 · S/N D-6944 N1721RStecher Allan · Thornton, COBuilt 1978 · S/N R18200534 N1721SLobpries Kyle J · Houston, TXBuilt 2009 · S/N 001 N17223Tao Farm LLC · Ririe, IDBuilt 2007 · S/N 172S10635 N1722CA G Sholton Co · Wasilla, AKBuilt 1953 · S/N 30422 N1722HWashington State Community College · Spokane, WABuilt 1959 · S/N 35822 N1722JDonah Thomas J · Plattsburgh, NYBuilt 1968 · S/N 28-24134 N1722TNoldin John · Griffith, INS/N D-7139 N1723ARegistration Pending · Kennesaw, GARegistration pendingBuilt 2026 · S/N 172S13507 N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190 N1723CDi Gangi Stephen S · Spokane, WABuilt 1953 · S/N 30423 N1723GDillahunty Chris D · Shaver Lake, CAS/N CD-486

Back to AD 2007-04-19 R1