OpenAirDocs.org
AD 2001-10-04 R1

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
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.

N5022CCleveland Air Service Inc · Cleveland, MSBuilt 1998 · S/N 502B-0479N5022SSchneider Ag Inc · Rugby, NDBuilt 2023 · S/N 502A-3420N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059N5028QTri Rotor Spray & Chemical · Ulysses, KSBuilt 1997 · S/N 401B-1028N502ADReabe Spraying Service Inc · Plover, WIBuilt 2016 · S/N 502B-3040N502AGBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 502A-3274N502AMScott Precision Aerial LLC · Oberlin, KSBuilt 2010 · S/N 502B-2698N502ARAir Care Leasing LLC · Lamar, COBuilt 1992 · S/N 502-0165N502BACrop-Serv Inc · Meade, KSBuilt 2010 · S/N 502B-2699N502BBStott Aerial Spray Inc · Jefferson, IABuilt 2018 · S/N 502A-3134N502BMPrecision Ag Air LLC · Lake Village, ARBuilt 1988 · S/N 502-0023N502BTRainey Aerial Ag Service Inc · Obion, TNBuilt 2009 · S/N 502B-2658N502CKPot Hook Leasing LLC · San Benito, TXBuilt 2022 · S/N 502A-3345N502CMWheels Down LLC · Buffalo Center, IABuilt 2010 · S/N 502B-2706N502CPMcelwain Russell · Lancaster, KSBuilt 2008 · S/N 502B2632N502DBDbl LLC · Hays, KSBuilt 2014 · S/N 502B-3007N502DEDavis Levi · Gratiot, WIBuilt 2009 · S/N 502B-2661N502DLCkw Aviation LLC · Dalhart, TXBuilt 1992 · S/N 502A-0176N502DSAir Dusters Inc · Roggen, COBuilt 1988 · S/N 502-0017N502EMDeby Ag Leasing Lp · Wakarusa, INBuilt 2022 · S/N 502A-3363N502FATaylors Flying Service Inc · Utica, MSBuilt 1993 · S/N 502-0217N502FDBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 502A-3402N502FFHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1998 · S/N 502B-0534N502GDBrett'S Spray Service Inc · Onida, SDBuilt 2007 · S/N 502B-2620N502GKMeyer Aviation Inc · Whittemore, IABuilt 2012 · S/N 502B-2794N502HABlackhawk Air LLC · La Porte City, IABuilt 2018 · S/N 502A-3144N502HCBoyd'S Aviation LLC · Rayville, LABuilt 2009 · S/N 502B-2690N502HDRosewood Air LLC · Plaucheville, LABuilt 2013 · S/N 502B-2899N502HFHowze Flying Services LLC · Banquete, TXBuilt 2023 · S/N 502A-3430N502HMMoores Aerial Applicators LLC · Clinton, NCBuilt 2024 · S/N 502A-3539N502HWNeal Aircraft Inc · Slaton, TXBuilt 2010 · S/N 502B-2695N502JAHoppe Air LLC · Beaman, IABuilt 1992 · S/N 502-0169N502JDDeterding Jim · Pond Creek, OKBuilt 2009 · S/N 502B-2656N502JFLejeune Aerial Applications LLC · Basile, LABuilt 2017 · S/N 502A-3114N502JKRoma Air Corp · Belle Glade, FLBuilt 1996 · S/N 502B-0373N502JPAcadian Dusters LLC · Church Point, LABuilt 1989 · S/N 502-0052N502JRJerrys Flying Service Inc · Wabbaseka, ARS/N 502B-2670N502JWBear Flying Service Inc · Sicily Island, LABuilt 1992 · S/N 502-0163N502KBMeyers Aerial Service LLC · Superior, NEBuilt 2011 · S/N 502B-2748N502KFForest Kevin · Langdon, NDBuilt 2011 · S/N 502B-2745N502KHWillmar Aerial Spraying Inc · Olivia, MNBuilt 2009 · S/N 502B-2666N502KSFoxtrot Air LLC · Highmore, SDBuilt 2009 · S/N 502B-2655N502LCCady Neil DBA · Rock Falls, ILBuilt 2011 · S/N 502B-2790N502LDH & G Farms · Corcoran, CABuilt 2013 · S/N 502B-2905N502LYR & R Flight Service Inc · Mendota, ILBuilt 2015 · S/N 502B-3013N502MBLepanto Crop Service Inc · Lepanto, ARBuilt 2023 · S/N 502B-3418N502MDRba LLC · Kimberly, IDBuilt 2008 · S/N 502B-2654N502MHWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 502-0164N502MKGeist Daniel C · Crookston, MNBuilt 1996 · S/N 502B-0356N502MSMid-State Aviation II Inc · Cozad, NEBuilt 2005 · S/N 502B-2588
Back to AD 2001-10-04 R1