Registered aircraft · 3,462

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:2002-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13') 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:2002-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
  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:2002-23-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
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.

N502MSMid-State Aviation II Inc · Cozad, NEBuilt 2005 · S/N 502B-2588 N502MVMidwest Aerial Spraying LLC · Dorchester, NEBuilt 2008 · S/N 502B-2621 N502NBWells Fargo Equipment Finance Inc · Clark, SDBuilt 2012 · S/N 502B-2814 N502NEWilcox Aerial Applications Inc · Tilden, NEBuilt 2012 · S/N 502B-2806 N502NJBretts Spray Service Inc · Onida, SDBuilt 1991 · S/N 502-0138 N502NLBoettcher Aerial Company Inc · Beloit, KSBuilt 2012 · S/N 502B-2837 N502NRHoelscher Rodney · San Angelo, TXBuilt 2012 · S/N 502B-2817 N502PAPost Rock Aviation Inc · Lincoln, KSBuilt 2012 · S/N 502B-2812 N502PBHershey Flying Service Inc · David City, NEBuilt 1998 · S/N 502B-0500 N502QDixie Flying Service Inc · Gilliam, LABuilt 1999 · S/N 502B-0573 N502RBDans Flying Service Inc · Crookston, MNBuilt 2010 · S/N 502B-2702 N502RCMid-State Avaition II Inc · Cozad, NEBuilt 1996 · S/N 502B-0348 N502RER And R Flight Service Inc · Mendota, ILBuilt 2008 · S/N 502B-2626 N502SDTri-County Ag Service Inc · Ipswich, SDBuilt 2015 · S/N 502B-3023 N502TGOld River Applicators LLC · Simmesport, LABuilt 1999 · S/N 502B-0538 N502TRSterling John A · Port Lavaca, TXBuilt 1999 · S/N 502B-0553 N502VBRegistered aircraftBuilt 2013 · S/N 502B-2886 N502VSValley Spraying Service LLC · Gann Valley, SDBuilt 2013 · S/N 502B-2889 N502WDOver And Under Flying Service DBA · Knox, INBuilt 1995 · S/N 502B0320 N502XH&G Farms Inc · Corcoran, CABuilt 2023 · S/N 502B-3423 N502XXRobinson Reid · Hollis, OKBuilt 1998 · S/N 502B-0532 N5034RMid Missouri Spray Service LLC · Richmond, MOBuilt 1996 · S/N 402B-1020 N5035KAmberican Aviation Inc · Grand Forks, NDBuilt 1997 · S/N 802-0048 N50383Sky Apply LLC · Hector, MNBuilt 1998 · S/N 502B-0493 N5039FDixie Flying Service Inc · Gilliam, LABuilt 1997 · S/N 402A-1031 N5039JDavis Blake · Bellevue, TXBuilt 1997 · S/N 502B-0454 N503ALPelegrin Northwest LLC · Bend, ORS/N EVO-025 N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514 N503GKKurtz Rural Aviation LLC · Mound City, MOBuilt 2014 · S/N 502B-2950 N503LMBig Sky LLC · Draper, UTBuilt 1997 · S/N FL-182 N503TATyree Ag Inc · Kinsley, KSBuilt 2009 · S/N 502B-2671 N5044NGrowers Air Service Inc · Woodland, CABuilt 1997 · S/N 502B-0452 N5046FMulder Air Inc · Renville, MNBuilt 1997 · S/N 502B-0455 N5048SBob Ruhe Ag Service LLC · Leipsic, OHBuilt 1998 · S/N 502B-0495 N504ATAerinova Aerial LLC · Mattoon, ILBuilt 2024 · S/N 504-4054 N504DDDigger Doug'S Crop Dusting Service Inc · Hollandale, WIBuilt 2022 · S/N 504-4042 N504HPFlorida Highway Patrol · Tampa, FLBuilt 2003 · S/N 514 N504HWFarm Air Flying Service LLC · Sacramento, CABuilt 2024 · S/N 504-4052 N504KQKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2009 · S/N 100-0028 N504WJVantage Air Corp · Kalispell, MTBuilt 1976 · S/N 503 N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039 N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066 N505DKBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N LJ-2071 N505PAutomotive Specialist LLC · Hopkins, MNBuilt 2003 · S/N 505 N505RFWalsh Engineering Services Pc · Idaho Falls, IDBuilt 2013 · S/N EVO-0046 N50623Redtail Inc · Wakarusa, INBuilt 1997 · S/N 502B-0458 N5063NSale Reported · Prattville, ALSale reportedBuilt 1997 · S/N 502B-0471 N50648Lindsey Aviation Services · Haslet, TXBuilt 1990 · S/N 20800191 N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045 N506HBS&D Spraying Service Inc · Panhandle, TXBuilt 2012 · S/N 502B-2799

Back to AD 2002-23-13