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.

N50071South Delta Aviation Inc · West Helena, ARBuilt 1996 · S/N 402B-1019 N5007GWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1997 · S/N 502B-0417 N5008LOlathe Spray Service Inc · Olathe, COBuilt 1996 · S/N 402B-1018 N5009SBrignac Flying Service LLC · Columbus, MSBuilt 1996 · S/N 502B-0402 N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387 N500HAWandering Quarks LLC · Lincolnville, MEBuilt 2005 · S/N 4697222 N500JM500jm Aviation LLC · Westfield, INBuilt 2001 · S/N 4697118 N500QKCat Air LLC · Miami, FLBuilt 2015 · S/N 100-0138 N500SEPjh Consulting LLC · Reno, NVBuilt 1994 · S/N FL125 N5010JGc Aviation LLC · Kalispell, MTBuilt 1997 · S/N 502B-0419 N5012CVan Namen Jonathan E · Benoit, MSBuilt 1997 · S/N 502B0411 N5018JRegistration Pending · Littlefield, TXRegistration pending, pending cancellationBuilt 1997 · S/N 502B-0432 N5019AReabe Spraying Service Inc · Plover, WIBuilt 1997 · S/N 502B-0415 N5019YAir Sprayers Inc · Two Buttes, COS/N 402A-1071 N501DUWaterside Holdings LLC · Knoxville, TNBuilt 1980 · S/N LA-82 N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565 N501KQAnjucan 501kq Inc · Middletown, DEBuilt 2010 · S/N 100-0046 N501MHBeta Ag Inc · Ralls, TXBuilt 2024 · S/N 502B-3473 N5022CCleveland Air Service Inc · Cleveland, MSBuilt 1998 · S/N 502B-0479 N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059 N502ADReabe Spraying Service Inc · Plover, WIBuilt 2016 · S/N 502B-3040 N502AMScott Precision Aerial LLC · Oberlin, KSBuilt 2010 · S/N 502B-2698 N502BACrop-Serv Inc · Meade, KSBuilt 2010 · S/N 502B-2699 N502BTRainey Aerial Ag Service Inc · Obion, TNBuilt 2009 · S/N 502B-2658 N502CMWheels Down LLC · Buffalo Center, IABuilt 2010 · S/N 502B-2706 N502CPMcelwain Russell · Lancaster, KSBuilt 2008 · S/N 502B2632 N502DBDbl LLC · Hays, KSBuilt 2014 · S/N 502B-3007 N502DEDavis Levi · Gratiot, WIBuilt 2009 · S/N 502B-2661 N502FATaylors Flying Service Inc · Utica, MSBuilt 1993 · S/N 502-0217 N502FFHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1998 · S/N 502B-0534 N502GDBrett'S Spray Service Inc · Onida, SDBuilt 2007 · S/N 502B-2620 N502GKMeyer Aviation Inc · Whittemore, IABuilt 2012 · S/N 502B-2794 N502HCBoyd'S Aviation LLC · Rayville, LABuilt 2009 · S/N 502B-2690 N502HDRosewood Air LLC · Plaucheville, LABuilt 2013 · S/N 502B-2899 N502HWNeal Aircraft Inc · Slaton, TXBuilt 2010 · S/N 502B-2695 N502JAHoppe Air LLC · Beaman, IABuilt 1992 · S/N 502-0169 N502JDDeterding Jim · Pond Creek, OKBuilt 2009 · S/N 502B-2656 N502JKRoma Air Corp · Belle Glade, FLBuilt 1996 · S/N 502B-0373 N502JRJerrys Flying Service Inc · Wabbaseka, ARS/N 502B-2670 N502JWBear Flying Service Inc · Sicily Island, LABuilt 1992 · S/N 502-0163 N502KBMeyers Aerial Service LLC · Superior, NEBuilt 2011 · S/N 502B-2748 N502KFForest Kevin · Langdon, NDBuilt 2011 · S/N 502B-2745 N502KHWillmar Aerial Spraying Inc · Olivia, MNBuilt 2009 · S/N 502B-2666 N502KSFoxtrot Air LLC · Highmore, SDBuilt 2009 · S/N 502B-2655 N502LCCady Neil DBA · Rock Falls, ILBuilt 2011 · S/N 502B-2790 N502LDH & G Farms · Corcoran, CABuilt 2013 · S/N 502B-2905 N502LYR & R Flight Service Inc · Mendota, ILBuilt 2015 · S/N 502B-3013 N502MBLepanto Crop Service Inc · Lepanto, ARBuilt 2023 · S/N 502B-3418 N502MDRba LLC · Kimberly, IDBuilt 2008 · S/N 502B-2654 N502MKGeist Daniel C · Crookston, MNBuilt 1996 · S/N 502B-0356

Back to AD 2002-23-13