Registered aircraft · 296

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:97-13-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-13-11') 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:97-13-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-13-11')
  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:97-13-11')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-13-11')
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 N107CANorth Applicair Corp · Panama City Beach, FLBuilt 1988 · S/N R1340011 N114JPJohnson Airspray Inc · Argyle, MNS/N T34-033 N127PBGilland Ag Service LLC · Elkton, TNBuilt 2009 · S/N T65-022DC N12LUDonalds Flying Service Inc · Pantego, NCBuilt 1998 · S/N T15-037DC N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150 N15NVNorth Valley Aircraft Inc · Valley City, NDBuilt 1978 · S/N 2475R N1637SKnutson Wayne R · Tioga, NDS/N 600-1186C N1658SSchwend Brian · Forsyth, MTBuilt 1964 · S/N 600-1217C N1663SSlater Richard J · Maddock, NDBuilt 1981 · S/N R1820-013DC N1664SAnderson Joel M · Starkweather, NDBuilt 1964 · S/N 600-1237D N1683SKnutson Wayne R · Tioga, NDBuilt 1965 · S/N 600-1266C N1697SGunia Michel L · Linton, NDBuilt 1965 · S/N 600-1257C N2042VAerial Crop Care Co · Hebron, NDBuilt 1998 · S/N G10-146 N20523Franklin Dirk W · Beaumont, TXBuilt 1998 · S/N G10-147 N20551Lane Christopher A · Lakeland, GAS/N T15-035 N2067BAgricair Leasing LLC · Bancroft, WIBuilt 1998 · S/N T34-246 N2068BTri-County Sprayers Inc · Hamlin, TXS/N T45-015 N2074JMauck Flying Service LLC · Hoxie, KSBuilt 1998 · S/N G1-109 N2076BArrowhead Aviation LLC · Louisville, ALBuilt 1998 · S/N T34-249 N20AFHawke Ag Aviation · Oakdale, CABuilt 1981 · S/N R1820-021DC N2103BQuad Rabbit Inc · Wilmington, DEBuilt 1998 · S/N G10-148 N2111TMccool Air Service Inc · Mc Cool Junction, NEBuilt 1998 · S/N T34-252 N2126TTidwell Sprayers Inc · Dimmitt, TXBuilt 1998 · S/N T15-038 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 N222GKTri-County Sprayers Inc · Hamlin, TXBuilt 1997 · S/N G6-145 N2237DFountain Flying Service LLC · Moscow, IDBuilt 1996 · S/N G1-104 N2237ZFlying G Aviation Inc · Drayton, NDBuilt 1996 · S/N 2591R N2239BBeery Milo A · Clarinda, IAS/N T41-217 N2239CJk Skyfarm LLC · Adairville, KYBuilt 1996 · S/N G10-128 N2239VNorth Star Aviation Inc · Ulysses, KSS/N G6-144 N2243JR & S Aviation LLC · Corning, ARBuilt 1996 · S/N T41-221 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 N2256LCrop Dusters LLC · Maurice, IABuilt 1997 · S/N T34-232 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 N22815Crop Dusters LLC · Maurice, IAS/N T34-239 N2281ADuck Hill Air Service LLC · Grenada, MSBuilt 1997 · S/N T15-034 N2292HNorth Florida Ag Services Inc · Lake City, FLBuilt 1999 · S/N T34-257 N22EHEd-Air Inc · Oaktown, INBuilt 1999 · S/N T34-265 N23034Crop Dusters LLC · Maurice, IABuilt 1999 · S/N T34-259 N2320TRegistration Pending · Walnut Ridge, ARRegistration pendingBuilt 1999 · S/N T34-260 N2329VWilliams Fertilizer Services LLC · Oregon, MOBuilt 1999 · S/N T34-262 N2530BSlf Air LLC · Bannister, MIS/N R1820006DC

Back to AD 97-13-11