Registered aircraft · 16,295

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N132VVolar Ix LLC · Edmond, OKBuilt 2025 · S/N 10625 N132VASpoto Charles · Johnsburg, ILBuilt 2025 · S/N 10590 N13331Cjc Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42528 N1333FMadrigales Jorge · Laredo, TXBuilt 2005 · S/N 1715 N1334XGiannetti Nicholas · Charlotte, NCBuilt 2007 · S/N 42510 N1336CMakson Leasing Co Inc · Salisbury, NCBuilt 2003 · S/N 0483 N133CDQualitair LLC Trustee · MichelstadtBuilt 2000 · S/N 1025 N133DR814ma Inc · Van Alstyne, TXBuilt 2005 · S/N 3255027 N133KBIsland Time Aviation LLC · Peachtree City, GABuilt 1996 · S/N 4636049 N133MCMohawk Flying Club Inc · Ada, MIBuilt 2010 · S/N 2054 N133PKFinn And Conway Inc · Bridgeview, ILBuilt 2004 · S/N 4697196 N133SRBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 4697114 N133WCRegistration Pending · Huntingdon, TNRegistration pendingBuilt 2000 · S/N 4636251 N1340MValiair Lc Trustee · Casper, WYBuilt 2006 · S/N 41666 N1341HAlseth Engineering LLC · Kirkwood, MOS/N 28-7790306 N1342HRobertson James P Trustee · Templeton, CABuilt 1977 · S/N 28-7790307 N1344HConner W Larry · Los Lunas, NMBuilt 1977 · S/N 28-7790308 N1345NHolco Solutions LLC · Wilmington, DEBuilt 2007 · S/N 41784 N1347CBlue Ridge Aero Inc · Berryville, VABuilt 2003 · S/N 0536 N134AJTimmermans Jamy · San Jose, CABuilt 2005 · S/N 1511 N134CKZhukov Yuriy Olegovich · Harrisonburg, VABuilt 2010 · S/N 3690 N134DSDoge Aircraft LLC · Boca Raton, FLBuilt 1982 · S/N 348233148 N134DWAtp Aircraft 1 LLC · Wilmington, DES/N 4496167 N134FCDepartment Of Agric & Consumer Svc/S · Tallahassee, FLBuilt 1982 · S/N 28-8290169 N134JSSparling Albert E · Hubbard Lake, MIBuilt 1968 · S/N 28R-30517 N134ME D Santos & Associates LLC Trustee · Wilmington, DEBuilt 2003 · S/N 4697169 N134MGCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233007 N134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483 N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593 N134PGRegistration Pending · Chicago, ILRegistration pendingBuilt 2008 · S/N 1935 N134PSBountiful Flight LLC · Woods Cross, UTBuilt 2004 · S/N 40.407 N134SRZabala Jaime · Naples, FLBuilt 2006 · S/N 1894 N134STBetancourt Ramses · Key West, FLBuilt 2006 · S/N 4692038 N134TC134tc LLC · Oklahoma City, OKBuilt 2019 · S/N 4808 N134WSKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2023 · S/N 28020137 N1355CC&E Aviation LLC · Kalispell, MTBuilt 2006 · S/N 41599 N1358CBrad Influence Llp · Wahpeton, NDBuilt 2003 · S/N 0529 N135DTDelta Tango Aviation LLC · Salt Lake City, UTBuilt 2007 · S/N 2690 N135EG305 Aviation Group Inc · Miami, FLS/N 28-8290170 N135FLAfdflt LLC · Mount Vernon, ILBuilt 2002 · S/N 4697135 N135JMBill White Transportation LLC · Poteau, OKS/N 4697072 N135JSHendo Horizon LLC · Carmel, INBuilt 2023 · S/N 9204 N135KDSkylight Aviation Corp Trustee · Wilmington, DEBuilt 2009 · S/N 3452 N135LANryk Air LLC · Greenville, NCBuilt 2022 · S/N 40.1233 N135MPDudjak Investments Group LLC · Sugar Land, TXBuilt 2023 · S/N 9615 N135MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496594 N135RPValiair Lc Trustee · Casper, WYS/N 3586 N135SRGunnin Larry · Simpsonville, SCBuilt 2006 · S/N 1898 N135TTAircruise LLC · Hobbs, NMBuilt 2010 · S/N 411158 N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015

Back to AD 2008-06-28 R1