OpenAirDocs.org
AD 2008-22-21

Registered aircraft · 564

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

N100FMajor Kens Flying Service LLC · Colfax, NDBuilt 1972 · S/N 1021N10202Tall Towers Ag Service Inc · Page, NDS/N 1N10210Mid Continent Aircraft Corp · Hayti, MOBuilt 1939 · S/N 10N10211Valley Air Service Ltd · Colusa, CABuilt 1959 · S/N 11N10215Trissell Flying Service Inc · Clarksville, TXBuilt 1960 · S/N 15N10218Porter Wade R · Chico, CABuilt 1959 · S/N 18N10247Ferrspray Aerial Application LLC · Marengo, ILBuilt 1960 · S/N 47N10250Adcock Colton L · Dustin, OKBuilt 1960 · S/N 50N10253Sipos Richard · Homosassa, FLBuilt 1960 · S/N 53N10254Trissell Flying Service Inc · Clarksville, TXBuilt 1960 · S/N 54N10256Triple F Flying Inc · Benton, PAS/N 56N10286Flying D Farm Inc · Kerhonkson, NYBuilt 1961 · S/N 86N10287Ripley James Jefferson III · Frederick, OKS/N 87N10294Miller Andy · Marana, AZS/N 94N10298Coen Aerial Spraying LLC · Wiley, COBuilt 1962 · S/N 98N118JDJacobson Luke W · Reno, NVS/N 863N127FCBurghduff Aviation LLC · Ludlow, SDS/N 1393N135VAWallace Aviation Inc · Wallace, NEBuilt 1976 · S/N 27BN13MZMcpherson Timothy L · Page, NDS/N 219N15ALRidgway Rick J · Carlisle, INBuilt 1976 · S/N 107N164APElwood Farms Inc · Levelland, TXBuilt 1977 · S/N 1706N164AZZumwalt Adam · Sheldon, ILS/N 26CN164GCAvag Inc · Richvale, CABuilt 1977 · S/N 2CN164JAOber John A · Candor, NYBuilt 1962 · S/N 277N164TAThompson Aero Inc · Amana, IABuilt 1980 · S/N 651BN164TNBuntings Dusting Inc · Berlin, MDBuilt 1978 · S/N 412BN16AAMcpherson Timothy L · Page, NDBuilt 1971 · S/N 792N1836CCascade Airways LLC · Jefferson, ORBuilt 1978 · S/N 36CN211ERMorgans Flying Service LLC · Morse, LABuilt 1977 · S/N 254BN211JMSanderson Grain Inc · Springlake, TXBuilt 1976 · S/N 69BN2236FWells Nathan S · Scotia, NEBuilt 1988 · S/N 807BN2437DMcclung Aerial Spraying Inc · Big Springs, NES/N 764BN2500WBasin Aviation Inc · Rio Oso, CABuilt 1982 · S/N 704BN27SKKingsley Kiman J · Miller, MOBuilt 1974 · S/N 1341N29GWRegistration Pending · Tyler, MNRegistration pendingBuilt 1975 · S/N 1564N2LUMowata Farms LLC · Mamou, LAS/N 595BN31GWHershey Flying Service Inc · David City, NES/N 507BN32RAZumwalt Aviation LLC · Sheldon, ILBuilt 1976 · S/N 31BN331YAirplane Services Inc · Jay, FLS/N 206N3407GRedditt Air Service Inc · Cleveland, MSBuilt 1978 · S/N 43CN342KGAviation Services Of Grady County Inc · Pelham, GABuilt 1977 · S/N 263BN34TFAlbertson James M · Slocomb, ALS/N 1724N36265Sutter Butte Dusters Inc · Live Oak, CABuilt 1983 · S/N 725 BN36269Mcclung Aerial Spraying Inc · Big Springs, NEBuilt 1983 · S/N 726 BN3626GSky Tractor LLC · Hillsboro, NDS/N 718BN36270Gilland Jonathan R · Elkton, TNS/N 734BN3627BAir Enterprises LLC · Dover, DES/N 727 BN3627GBuntings Dusting Inc · Berlin, MDBuilt 1983 · S/N 729 BN3627QSutter Butte Dusters Inc · Live Oak, CABuilt 1983 · S/N 730 BN3627SJackieson LLC · Kaplan, LAS/N 732B
Back to AD 2008-22-21