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 ('1151408')
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 ('1151408')
ORDER BY n_numberRun 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.
N58UWayne F Little LLC · Portage, MIN5908STkc Aviation Inc · San Diego, CAN5949SN5949s LLC · Hereford, TXN6004FRiefkohl Matt R · Bellville, TXN6017FHirsch Richard B · Russellville, KYN6022FChurch Bill H · Sodus, MIN6024FRowe Daniel R · Mckinney, TXN6037FThacher Colin D · Fort Worth, TXN6038FPajam LLC · Lake In The Hills, ILN6046FAckard David A · Claridge, PAN6047FDebonair Air LLC · Austin, TXN6073FRivera Anthony R · Nevada City, CAN6101VSteiner Dirk · Williamson, GAN6102VBurns Shane · Waxahachie, TXN6103VNolen Steven Scott · Tucson, AZN6124VMoellring David H · Fowler, ILN6125VSouthwest Traffic Systems Inc · Phoenix, AZN6126VKa Aviation LLC · Hermiston, ORN6128VSheffel Patricia S · Oro Valley, AZN6129VFilippini Brian · Philadelphia, PAN6131VTail Number Pending LLC · San Antonio, TXN6133VOmni Directions Inc · Roanoke, VAN6134VPar Aviation LLC · Lewes, DEN6142VPesuit Roger · Fullerton, CAN6143VVanzee Robert A · Hudsonville, MIN619RPBarrett Kendall · Murfreesboro, TNN6219VJohanson Karl S · San Diego, CAN6228VMontana Aviation Tryst LLC · Kalispell, MTN63HMDouglas John R · Granite Falls, NCN6533CKnopp John · Montgomery, TXN653PRuptured Duck LLC · Mesa, AZN664WYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN6664CValiair Limited Company Trustee · Casper, WYN67LTSky West Aviation Inc Trustee · Albuquerque, NMN67STSparrow Aviation Inc · Richmond, KYN713BSAdams David J · Fredericksburg, VAN717JSKelly Stephen R · Appleton, WIN717JTZajkowski Peter J · Poughkeepsie, NYN753WMehrer Fritz J · El Cajon, CAN75KWRegistered aircraftN769CBMckinnon Aviation LLC · Gilbert, AZN7877LH & M Air LLC · Shelbyville, KYN7878LColquitt Jeff B · Canton, TXN7916MMiami Palm LLC · Palm City, FLN7918MCaylor Robert M · Sandston, VAN791MTruby Charles M · Boerne, TXN7929MByrne Computerworks Inc · Owensboro, KYN7943MJ&W Aircraft Inc · Grandview, TXN7945MPearce Robert · Corte Madera, CAN796LMN796lm LLC · West Bloomfield, MI
Back to Beech 35-C33