Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N8323WConcord Aviation Services LLC · Concord, NHBuilt 1965 · S/N 28-2500 N8324WSwofford Sherman A · Inman, SCBuilt 1965 · S/N 28-2501 N8325RSy Aviation LLC · Judsonia, ARS/N 28-22197 N8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 28-2502 N8326WBarnwell Sam M · Traverse City, MIBuilt 1965 · S/N 28-2504 N8327RWelsh Rick F · Ewing, VABuilt 1966 · S/N 28-22199 N8327WFuture Flying LLC · Manassas, VABuilt 1965 · S/N 28-2506 N8328WTolmachev Nikolay A · Anchorage, AKBuilt 1965 · S/N 28-2507 N8330RBriggs Michael L · Howell, MIBuilt 1966 · S/N 28-22202 N8330WRed Rock Flying School LLC · Mesa, AZS/N 28-2510 N8332RDelehanty Sean M · Mattituck, NYBuilt 1966 · S/N 28-22204 N8332WSurls Aviation Inc · Peculiar, MOBuilt 1965 · S/N 28-2512 N8333WKeeble Robert H Sr · Loudon, TNBuilt 1965 · S/N 28-2514 N8335WHiatt Ronald G · Forestburgh, NYBuilt 1965 · S/N 28-2516 N8336RSmith Gerald A Trustee · Bow, NHBuilt 1966 · S/N 28-22209 N8336WJd Aviation LLC · Omaha, TXBuilt 1965 · S/N 28-2518 N8338CBean Eric J · Canton, NCBuilt 1976 · S/N 28-7625103 N8338RMarshall Rodney V · Riverton, UTBuilt 1966 · S/N 28-22211 N8338WL A S LLC · Fort Leavenworth, KSBuilt 1965 · S/N 28-2520 N8339RGonzalez Karina · Bloomfield, NJFirst renewal noticeBuilt 1966 · S/N 28-22213 N8339WYoung Stanley K · Edmond, OKBuilt 1965 · S/N 28-2522 N833WTN833wt LLC · Lake City, FLBuilt 1969 · S/N 28-26090 N8340RJohnson Darrell Thomas IV · Yemassee, SCBuilt 1966 · S/N 28-22214 N8340WFasbender Brady T · Menomonie, WIBuilt 1965 · S/N 28-2523 N8341RMartin Dennis R · Lake Placid, FLBuilt 1966 · S/N 28-22215 N8342RCaleb Cooper 2 LLC · Pinellas Park, FLBuilt 1966 · S/N 28-22216 N8343RLedford Larry L · Stone Mountain, GABuilt 1966 · S/N 28-22217 N8343WWaid Fred M · Abilene, TXS/N 28-2527 N8345RKlad-Air LLC · Catlett, VABuilt 1966 · S/N 28-22219 N8346WBurns C R · Huntsville, ALBuilt 1965 · S/N 28-2532 N8348RMorris Jeff L · Radcliffe, IAS/N 28-22223 N8348WAmerican Equipment Sales Inc · Lawrence, KSBuilt 1965 · S/N 28-2535 N8349WGrayhawk Flight Training LLC · Lucas, TXBuilt 1965 · S/N 28-2536 N834DVVeith Donald C · Cattaraugus, NYBuilt 1972 · S/N 28-7305159 N8350RPerinoni Edward Jr · Novato, CABuilt 1966 · S/N 28-22225 N8350WJr Aviation Holdings LLC · Newark, DEBuilt 1965 · S/N 28-2538 N8352RQuantum Aviation LLC · Wauna, WABuilt 1966 · S/N 28-22227 N8352WLebanon Flying Club · Lebanon, MOBuilt 1965 · S/N 28-2540 N8353RSchrandt Mark L · Shoreview, MNBuilt 1966 · S/N 28-22228 N8353WN8353w Flyers LLC · North Las Vegas, NVS/N 28-2542 N8354RStonebrink Grant · Boonton, NJBuilt 1966 · S/N 28-22229 N8354WCoombs Eric S · Louisburg, NCBuilt 1965 · S/N 28-2543 N8356WSmith Randall K · Wilton, CABuilt 1965 · S/N 28-2547 N8357RRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1966 · S/N 28-22233 N8358RHight Mayon C · Snohomish, WABuilt 1966 · S/N 28-22234 N8358WChaney Eddie L · Douglas, GABuilt 1965 · S/N 28-2550 N8359WMarble Jere D · Dayton, NVBuilt 1965 · S/N 28-2551 N8361WBursch Clint Lee · Bird City, KSBuilt 1965 · S/N 28-2556 N8362RCore Flight Academy LLC · Asheboro, NCBuilt 1966 · S/N 28-22344 N8362WSexton Rick C · Payson, AZBuilt 1965 · S/N 28-2557

Back to AD 96-10-01 R1