Registered aircraft · 144

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

N1009FDavidson Richard E · Tchula, MSBuilt 2019 · S/N T34-484 N127PBGilland Ag Service LLC · Elkton, TNBuilt 2009 · S/N T65-022DC N1663SSlater Richard J · Maddock, NDBuilt 1981 · S/N R1820-013DC N2042VAerial Crop Care Co · Hebron, NDBuilt 1998 · S/N G10-146 N20523Franklin Dirk W · Beaumont, TXBuilt 1998 · S/N G10-147 N2068BTri-County Sprayers Inc · Hamlin, TXS/N T45-015 N2074JMauck Flying Service LLC · Hoxie, KSBuilt 1998 · S/N G1-109 N2103BQuad Rabbit Inc · Wilmington, DEBuilt 1998 · S/N G10-148 N2136TWalvoord Spraying Service LLC · Hickman, NEBuilt 1998 · S/N G6-148 N2146SMoses Lake Warden Air Services Inc · Moses Lake, WABuilt 1998 · S/N G10-149 N2200QCarroll Flying Service Inc · Lake Providence, LABuilt 1998 · S/N G10-155 N2237DFountain Flying Service LLC · Moscow, IDBuilt 1996 · S/N G1-104 N2239CJk Skyfarm LLC · Adairville, KYBuilt 1996 · S/N G10-128 N2239VNorth Star Aviation Inc · Ulysses, KSS/N G6-144 N2245SFernandez Rosario Yailin · Imperial, CAS/N G1-106 N2250PPeterson Kenneth J DBA · Staples, MNBuilt 1997 · S/N G10-131 N2254SRustys Flying Service · D Hanis, TXS/N G10-134 N2256ATwin Cities Aviation Inc · Yuba City, CABuilt 1997 · S/N G10-135 N2270CBenrud Aviation LLC · Rice, MNBuilt 1997 · S/N G10-136 N2270SEarls Spray Service Inc · Breckenridge, MIBuilt 1997 · S/N G10-137 N2271ZPlane LLC (The) · Grove, OKBuilt 1997 · S/N G6-147 N2530BSlf Air LLC · Bannister, MIS/N R1820006DC N25CTAerial Crop Care Co · Hebron, NDBuilt 1996 · S/N G1-105 N263JCAllen Chorman & Son Inc · Milton, DEBuilt 2004 · S/N T34HG-105 N283TATommys Flying Service · Sherrill, ARBuilt 2009 · S/N T34-314DC N3000HNorth Florida Ag Services Inc · Lake City, FLBuilt 2012 · S/N T34-402 N30019O & K Aviation Inc · Newport, ARS/N T45007DC N3004KAg Solutions LLC · Satanta, KSBuilt 1994 · S/N G10109 N3004VCarroll Flying Service Inc · Lake Providence, LABuilt 1995 · S/N G6120 N3006CNewkirk Thomas DBA · Garland, NCBuilt 2012 · S/N T34-403 N3024ULarson Ag Inc · Stephen, MNBuilt 1994 · S/N G10-108 N3043VMccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-422 N3045HPesicka Theodore J · Hermiston, ORBuilt 2013 · S/N T34-411 N3052VFederal Aerial Applicators LLC · Wilmington, DEBuilt 2012 · S/N T34-374 N3055MChorman Spraying LLC · Milton, DEBuilt 2012 · S/N T34-381 N30601Longwood Flying Service Inc · Hollandale, MSBuilt 2012 · S/N T34-400 N3060DMcelwain Russell · Lancaster, KSBuilt 2012 · S/N T34-383 N3061NGreat Plains Spraying Inc · Colby, KSBuilt 2012 · S/N G10-174 N30620Mccool Air Service Inc · Mc Cool Junction, NEBuilt 2013 · S/N T34-407 N3067XSamson Ag Flying LLC DBA · Wilmington, DEBuilt 2006 · S/N T34-278 N3083ZSilverwings Ag LLC · Burlington, COBuilt 1995 · S/N G6-122 N3091RWilde Air Service LLC · Volga, SDBuilt 1992 · S/N G6-107 N3097LWest Central Ag-Air Inc · Fergus Falls, MNBuilt 1991 · S/N G6-101 N3105USherman Aviation Inc · Redmond, ORBuilt 1992 · S/N G6-108 N3153WCe-Air Inc · Argyle, IAS/N G6-124 N318LGLow Go Flyers Inc · Jonesville, LABuilt 2014 · S/N T34-421DC N31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008 N32064Kingsley Kaland W · Miller, MOS/N G10-113 N3291VShelton Agri Services Inc · Hereford, TXBuilt 1995 · S/N G6-129 N32973Crop Jet Aviation LLC · Gooding, IDBuilt 1995 · S/N T45-009

Back to AD 2000-11-16