Skip to content

Christen Industries A-1

Registered aircraft · 81

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('221020X')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('221020X')
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.

N103TBSugasa David · Imlay, NVBuilt 1989 · S/N 1078 N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013 N141PAMosley John E · Jackson, MSBuilt 1990 · S/N 1115 N14VVHusky Air Corp · Scipio Center, NYBuilt 1988 · S/N 1057 N20495Pitts Dan O · Soldotna, AKBuilt 1988 · S/N 1045 N225YWhite Wings LLC · Anchorage, AKBuilt 1990 · S/N 1133 N2864WSpearhead Ranch LLC · Douglas, WYBuilt 1987 · S/N 1001 N2866BBulger Edward P · Newburyport, MAS/N 1002 N2868DMayer Larry A · Billings, MTBuilt 1987 · S/N 1004 N2868MEngler Eric M DBA · Cass City, MIBuilt 1987 · S/N 1005 N28706Kalus Joseph G · Afton, WYBuilt 1987 · S/N 1007 N2870DBardsley Lucas A · Sutton, AKBuilt 1987 · S/N 1006 N2878XKing Jennifer M · Eagle River, AKBuilt 1987 · S/N 1008 N2879TWark John Charles · Pueblo, COBuilt 1987 · S/N 1009 N28808Aba Aviation LLC · Buford, GABuilt 1987 · S/N 1010 N2881PChicago Glider Club · Minooka, ILBuilt 1987 · S/N 1011 N28820Elite Flying Group LLC · Northampton, MABuilt 1987 · S/N 1014 N28957Western States Holdings LLC · Sheridan, WYBuilt 1987 · S/N 1016 N2895RCarlson Aaron J · La Villa, TXBuilt 1987 · S/N 1015 N28973Coffman Joseph Bryan · North Pole, AKBuilt 1987 · S/N 1018 N2897UWwe LLC · Ridgway, COBuilt 1987 · S/N 1017 N2898DMerritt Robert L · Afton, WYS/N 1019 N29076Flight Dynamics LLC · De Leon Springs, FLBuilt 1987 · S/N 1022 N2908UBarrett H Gould · Myrtle Beach, SCS/N 1023 N2912XAmbler Carlos S · Mendota, ILBuilt 1987 · S/N 1025 N29131Kelly Alex · Arlington, VTBuilt 1987 · S/N 1027 N2913ATruesdell Shannon · Stephenville, TXBuilt 1988 · S/N 1062 N2914QEast High Flying · Othello, WABuilt 1987 · S/N 1028 N2918LHieb Jared J · Amarillo, TXBuilt 1987 · S/N 1030 N2925ZEngler Eric M DBA · Caro, MIBuilt 1988 · S/N 1032 N2928HLibby Matthew P · Castle Hill, MEBuilt 1988 · S/N 1037 N2932WSchweller Ronald L · Wilmington, OHBuilt 1989 · S/N 1084 N29421American Aerial Scenes · Pompey, NYS/N 1041 N2945WFly Middle Hero LLC · Grand Isle, VTBuilt 1988 · S/N 1066 N2947VEd Henderson LLC · Bowling Green, MOS/N 1085 N29486Lee Kevin M · Rexburg, IDBuilt 1988 · S/N 1055 N2950QGriffin Russell A · Jackman, MEBuilt 1988 · S/N 1046 N29510N29510 LLC · Farmington, UTBuilt 1988 · S/N 1047 N29561St Onge Adam R · Sterling, AKBuilt 1988 · S/N 1069 N2960WDawson Ben J · Milton Freewater, ORS/N 1099 N2965TKubecka Dick · Palacios, TXBuilt 1988 · S/N 1053 N2967XStephens Jason L · Gilbert, AZBuilt 1988 · S/N 1054 N29718Diamond H Ranch Inc · Kemmerer, WYBuilt 1989 · S/N 1074 N2974QCox Alexander B · Mullen, NEBuilt 1988 · S/N 1060 N29EWReady Aim Flyer LLC · New Castle, DEBuilt 1986 · S/N 1000 N325XJahn Paul B · Nevis, MNBuilt 1989 · S/N 1086 N42288Welsh Christopher R · Cresson, TXBuilt 1996 · S/N 1329 N4803Molek Jon · Warren, OHS/N 1126 N500PWSilver Peak Consulting LLC · Bozeman, MTS/N 1100 N500TEGovers Harald · Mesa, AZBuilt 1988 · S/N 1048

Back to Christen Industries A-1