Skip to content

AD 2001-10-04 R1

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.

N6126UR & D Leasing Inc · Lemoore, CABuilt 1995 · S/N 502A-0298 N6128WWhitten Flying Service Equipment LLC · Snook, TXBuilt 1996 · S/N 402B-1002 N6129XAg-Aviators Inc · Nashville, GABuilt 1995 · S/N 502B-0304 N612LAWindsock Skies LLC · Caldwell, TXBuilt 2015 · S/N 802A-0601 N61315East Air Aviation LLC · Hanceville, ALBuilt 1995 · S/N 502B-0305 N6131KLt Development Group LLC · Watford City, NDBuilt 1995 · S/N 802A-0016 N6132AMaco Aviation Inc · Dayton, WABuilt 1995 · S/N 502B-0295 N6132WWest Hills Aviation Inc DBA · Huron, CABuilt 1995 · S/N 502B-0309 N6133RReed Aviation Inc · Iota, LABuilt 1995 · S/N 502B-0300 N6134QEast Air Aviation LLC · Hanceville, ALBuilt 1995 · S/N 502B-0306 N6134YEsoteric Aviation LLC · Turner, MTBuilt 1995 · S/N 502B-0308 N61352Cotton Ag Inc · Walters, OKS/N 502B-0311 N61366Plantation Flyers LLC · Lettsworth, LABuilt 1996 · S/N 502B-0374 N6136HAurora Cooperative Elevator Company · Aurora, NEBuilt 1995 · S/N 802A-0017 N6136MEdwards Flying Service Inc · Leland, MSBuilt 1995 · S/N 502B-0341 N6139VRussel Armstrong & Danny Hawk DBA Onstott Dusters · Yuba City, CABuilt 1995 · S/N 402B-0982 N6142MGentrys Flying Service LLC · Prattville, ALBuilt 1994 · S/N 502B-0269 N6143LCkw Aviation LLC · Dalhart, TXBuilt 1996 · S/N 502A-0350 N6146WAdara Aircraft LLC · Hamilton, MTS/N 401B-0979 N61481Aerial Crop Protection Inc · Belle Glade, FLBuilt 1996 · S/N 502B-0371 N6148TAllen Air Ltd LLC · Wray, COBuilt 1995 · S/N 802A-0022 N614LAWindsock Skies LLC · Caldwell, TXBuilt 2016 · S/N 802A-0647 N614MWCrider Flying Service Inc · Swifton, ARBuilt 2000 · S/N 502A-0614 N6159FAero Spray Inc DBA · Appleton, MNBuilt 1996 · S/N 802A-0029 N6160GChapman Cody A · Wray, COS/N 502B-0358 N6164QRunsick Michael C DBA · Wynne, ARBuilt 1996 · S/N 502B-0384 N6165CAir Care Leasing LLC · Lamar, COBuilt 1996 · S/N 502B-0379 N6165UTailwinds Air Inc · Morganza, LABuilt 1996 · S/N 502B-0381 N61664Arthur Aviation LLC · Arthur, NDBuilt 1996 · S/N 502B-0382 N616JBAdams Aerial Solutions LLC · Decatur, ILBuilt 1997 · S/N 402A-1033 N6170XWest Hills Aviation Inc · Huron, CABuilt 1996 · S/N 502B-0372 N6174HWoodley Aerial Leasing LLC · Walnut, ILBuilt 1995 · S/N 402B-0994 N6175STri-Rotor Spray And Chemical · Ulysses, KSBuilt 1995 · S/N 402B-0993 N61762Chisenhall Agricultural Service Inc · Foley, ALBuilt 1996 · S/N 401B-1008 N6176LTrinkle Aviation LLC · Kingsburg, CABuilt 1996 · S/N 502A-0352 N6176YRegistered aircraftBuilt 1996 · S/N 802-0036 N61775Cruce Aviation LLC-Series Leasing · Marquette Heights, ILBuilt 1996 · S/N 401B-1009 N6177JMcginty Flying Service LLC · Jones, LABuilt 1995 · S/N 502B-0327 N6180UParrish Aerial Services LLC · Wilmington, DEBuilt 1996 · S/N 502B-0390 N6181QPioneer Agviation 2 LLC · Holdrege, NEBuilt 1996 · S/N 502B-0395 N618LAMiles Flying Service Inc · Bono, ARBuilt 2019 · S/N 802-0818 N619BBOver And Under Flying Service DBA · Knox, INS/N 401-0916 N619LAArg Aviation LLC · Lexa, ARS/N 802-0221 N619PFDel Ag Aero LLC · Milton, DEBuilt 2015 · S/N 802A-0619 N622JATri-Rotor Spray And Chemical Inc · Ulysses, KSBuilt 2008 · S/N 502B-2622 N62370Bell Flying Inc · Newport, ARBuilt 2019 · S/N 802A-0787 N623BFHiggins Leasing Inc · The Woodlands, TXBuilt 2020 · S/N 802A-0827 N623LANeal Aircraft Inc · Slaton, TXBuilt 2000 · S/N 402A-1127 N624BFBrb LLC · Lewes, DEBuilt 2022 · S/N 802A-0934 N625BFBrb LLC · Lewes, DEBuilt 2024 · S/N 802A-1086

Back to AD 2001-10-04 R1