Registered aircraft · 1,468

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.

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 N502PVWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2022 · S/N 502A-3355 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 N502RSSwing Wing Inc · Veedersburg, INBuilt 2024 · S/N 502A-3501 N502SBGross Flying Service Inc · Larned, KSBuilt 2023 · S/N 502A-3428 N502SDTri-County Ag Service Inc · Ipswich, SDBuilt 2015 · S/N 502B-3023 N502SEWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2024 · S/N 502A-3486 N502SMBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 502A-3186 N502SSSchneider Aerial Inc · Rugby, NDBuilt 2023 · S/N 502A-3416 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 N502WFBank Of Utah Trustee · Salt Lake City, UTS/N 502B-2646 N502XH&G Farms Inc · Corcoran, CABuilt 2023 · S/N 502B-3423 N502XPLow Altitude Applications LLC · Denton, MDBuilt 2016 · S/N 502A-2945 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 N503FAMccaleb'S Flying Service LLC · Plaucheville, LABuilt 2013 · S/N 802A-0503 N503GKKurtz Rural Aviation LLC · Mound City, MOBuilt 2014 · S/N 502B-2950 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 N5059JTanner Flying Service Inc · Cortez, COBuilt 1997 · S/N 402B-1039 N5059VKross Lessyn Aerial Inc · Hereford, TXBuilt 1998 · S/N 402B-1066 N505FAAir Cover Crop Solutions LLC · Frankford, MOBuilt 2013 · S/N 802A-0505 N50623Redtail Inc · Wakarusa, INBuilt 1997 · S/N 502B-0458 N5063NSale Reported · Prattville, ALSale reportedBuilt 1997 · S/N 502B-0471 N5066CFarm Ag Enterprises LLC · Buckeye, AZBuilt 1997 · S/N 802A-0045 N506FAPontiac Flying LLC · Pontiac, ILBuilt 2014 · S/N 802A-0572 N506HBS&D Spraying Service Inc · Panhandle, TXBuilt 2012 · S/N 502B-2799 N5075LAslesen Leasin LLC · Halstad, MNBuilt 1998 · S/N 502B-0480 N5075PPeterson Tony D · Humboldt, IABuilt 1997 · S/N 502B-0439 N50761Arthur Aviation LLC · Arthur, NDBuilt 1998 · S/N 402A-1065

Back to AD 2001-10-04 R1