Registered aircraft · 1,467

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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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.

N847FAAerial Crop Services LLC · East Prairie, MOBuilt 2020 · S/N 802-0847 N848HAAerial Applicators Of Missouri LLC · Qulin, MOBuilt 2020 · S/N 802A-0868 N84FCWilliams Fertilizer Services LLC · Oregon, MOBuilt 1994 · S/N 402-0946 N85022Bergo LLC · Harrisburg, ARBuilt 2001 · S/N 402A-1140 N8502ATumbleweed Leasing LLC · Tacoma, WABuilt 2002 · S/N 502-0647 N8502HPope James D · Lewiston, IDS/N 802-0140 N8503WPioneer Agviation 2 LLC · Holdrege, NES/N 802A-0134 N8504RRussell Armstrong And Danny Hawk DBA · Yuba City, CABuilt 2001 · S/N 802A-0123 N8504TWakefield Aircraft LLC · Cooperstown, NDBuilt 2005 · S/N 802A-0218 N8505EVisser Ag Inc · Rigby, IDFirst renewal noticeS/N 802A-0133 N8506VKubecka Daniel P · Edna, TXBuilt 2003 · S/N 502B-0650 N8507KA & M Flying Service Inc · Carlise, ARBuilt 2001 · S/N 802A-0122 N8507NTumbleweed Leasing LLC · Tacoma, WABuilt 2003 · S/N 802A-0158 N8507SVan Namen Jonathan · Benoit, MSBuilt 2003 · S/N 502B-0664 N8509SAir Tractor Inc · Olney, TXBuilt 2003 · S/N 802A-0164 N8509TCrop Jet Aviation LLC · Gooding, IDS/N 802A-0152 N850WRAg-Tech Aviation Inc · Leland, MSBuilt 2001 · S/N 502B-0643 N8512FR & D Leasing Inc · Lemoore, CAS/N 802A-0215 N8512LAdvance Flight Training & Leasing LLC · South Saint Paul, MNBuilt 2004 · S/N 802-0170 N8513QTri-Air Farms LLC · Mamou, LABuilt 2002 · S/N 802-0127 N8513VSyf LLC · Okmulgee, OKS/N 802-0128 N8516KFlatland Aviation LLC · Indianola, MSBuilt 2003 · S/N 502B-0669 N8519VAdams Aerial Solutions LLC · Decatur, ILBuilt 2004 · S/N 502B-0686 N851BFF & M Flying Service LLC · Columbus, MSBuilt 2022 · S/N 802A-0996 N851CHCkw Aviation LLC · Dalhart, TXBuilt 2024 · S/N 802A-1170 N851DCKansas Farm & Ranch Inc · Seneca, KSBuilt 2021 · S/N 802A-0921 N851LASun Valley Dusting Co · San Benito, TXBuilt 2014 · S/N 502A-2951 N8520ZSyf LLC · Okmulgee, OKBuilt 2004 · S/N 802-0184 N8521PThomas Air Service Inc · Hastings, NEBuilt 2004 · S/N 402B-1148 N8521QCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2005 · S/N 502B-2572 N8521WA & M Flying Service Inc · Carlisle, ARBuilt 2004 · S/N 802A-0167 N8521ZAir Care Leasing LLC · Lamar, COBuilt 2004 · S/N 502B-0693 N8522SDodson International Parts Inc · Rantoul, KSBuilt 2003 · S/N 802A-0161 N8522YAero Applications Inc · Burley, IDBuilt 2004 · S/N 802A-0188 N8523JA & M Flying Service Inc · Carlisle, ARBuilt 2011 · S/N 802A-0394 N8523LTwin Cities Aviation Inc · Yuba City, CABuilt 2005 · S/N 802A-0203 N8524HMitchell Andrew D Trustee · Winnie, TXS/N 802A-0163 N8524LTri Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N 802A-0202 N8524QMid-Cal Ag Aviation Inc · Kerman, CABuilt 2005 · S/N 502B-2580 N8525DNeal Aircraft Inc · Slaton, TXS/N 802A-0172 N8525FJlr Ag Aircraft LLC · Fowler, COBuilt 2005 · S/N 402B-1169 N8525QMagnum Aviation LLC · Goff, KSBuilt 2005 · S/N 802A-0222 N8525VKing Ag Leasing Inc · Sudan, TXS/N 502B-2568 N8526HOld River Applicators LLC · Simmesport, LABuilt 2006 · S/N 502B-2595 N8526LJack Olham Oil Inc · Dumas, TXBuilt 2005 · S/N 402B-1167 N852DK402wd Holdings LLC · Corpus Christi, TXBuilt 2013 · S/N 502A-2904 N854FAAdams Aerial Solutions LLC · Decatur, ILBuilt 2024 · S/N 802A-1130 N855LAWilmot Airplane Ventures LLC · Mer Rouge, LABuilt 2022 · S/N 802A-0952 N855NFNew Frontier Aviation LLC · Fort Benton, MTBuilt 2008 · S/N 802A-0317 N858AAAg Aviation Inc · Muleshoe, TXBuilt 2019 · S/N 802A-0798

Back to AD 2001-10-04 R1