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.
N4455VHorsefly Aviation LLC · Helena, MTN469AWest Werner Anita L · Frankford, DEN4819JDoran Jeffrey T · Westerville, OHN4832JApex Trucking Inc · Park City, KSN4887JKuczak Patricia J · Dayton, OHN4888JFisher Bryan S · Galveston, TXN4VGGutierrez Eduardo · Burbank, CAN500HTJones Angela K · Lenoir City, TNN501RADalton Charles · Auburn, NYN513PTLake Timothy Michael · Murfreesboro, TNN5432UEberling Bill · Central Point, ORN5452UAlchemist Aviation LLC · Tallahassee, FLN5492ULawrence Christopher L · Panama City, FLN5494UEdwards Michael L · Mesilla Park, NMN55HHWeir William K · Boylston, MAN5648SWinged Warriors Aviation LLC · Doylestown, PAN567BCDenton James A Trustee · Lompoc, CAN5717VGleason Michael · Prescott, AZN5757D57 Delta LLC · Grand Prairie, TXN5808KBishop H Ray · Lovington, NMN5809KBaxley Andrew · Edwards, CAN5810KLocke Leldon W · Sherman, TXN5814KPeterson Deanna R · Canby, ORN5816KWilliams Walter C · New Berlin, TXN5817KMunsch James R · Algonquin, ILN5820KBsmm LLC · Bellingham, WAN5821KAltizer Darrell B · Peru, NYN5822KFoxtrot International LLC · Woodland Hills, CAN5837SDonham William David · Odessa, TXN5844KMotion Marketing Inc · Shawnee, KSN5851JHancock Tim · Viola, TNN5853JZanuzoski Alan K · Hillsboro, ORN5854JWilliams Lloyd S · Mine Run, VAN5856JFord Alan C · Madison, CTN5861SWilson James G · Vero Beach, FLN5863SStone Dynamics Inc · Martinsville, VAN5865SHartnett Bennett M · Moultonborough, NHN5866JWendel Mikel P · Elkhart, INN5870SToo Slick LLC · Greenwood, INN5871SSteckman Benjamin L · Coeur D Alene, IDN5873JAmick Dennis W · Wessington Springs, SDN5875STake Flight Endeavors LLC · Hartselle, ALN5878SCaelum Ga LLC · Suwanee, GAN5879JBmp Logic Inc · Trenton, FLN5880JMcnamara Michael T · Pottstown, PAN5881SNelson Daniel J · Ladd, ILN5882SSkinner Gregory · Prosper, TXN5891JPlantation Reclaimed Inc · Knoxville, TNN5891SDakota Aero Inc · Wilmington, DEN5892SGreat Plains Enterprises LLC · Wilmington, OH
Back to Beech 35-C33