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 ('2073303')
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 ('2073303')
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.
N2268BNitro Aviation LLC · Englewood, CON2269BAh1f Associates LLC · Clifton Park, NYN226MELawson Tim · San Clemente, CAN2272DLucky Marmot Aviation LLC · Traverse City, MIN2272PSchmitz William M · Napa, CAN228HSSweeney David H · Houston, TXN22CHSupergo LLC · Menlo Park, CAN2301QFarm West LLC · Missoula, MTN23207Ttp Aviation LLC · Concord, NCN23215Bill Webb Construction Inc · Chico, CAN232TJCsc Delaware Trust Co Trustee · Wilmington, DEN234HESchniederjan William Jason · Dalhart, TXN2353HBlackbird Enterprises LLC · Las Vegas, NVN2365FBottorff Jon C · Fishers, INN2365JBrosius Michael W · North Platte, NEN2370XSouthwest Aircraft Enterprises · Haslet, TXN2371HSan Jose Aviation LLC · Mission, TXN23781Paragon Air Group · Fort Worth, TXN2378XState Of Utah · Salt Lake City, UTN2378YLindsey Aviation Services · Haslet, TXN2379FWebster Douglas Clark · Las Vegas, NVN2381YInvictus Investments LLC · Urbandale, IAN2383LNebraska State Patrol · Lincoln, NEN2389GMacon Septic Systems Co Inc · Macon, MSN2389LCjw Holdings LLC · Stamping Ground, KYN238TLLow Sean · Midland, TXN2391EInnova Energy LLC · Wilmington, DEN2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKN240CPCivil Air Patrol · Maxwell Afb, ALN240PSN240ps LLC · Mesa, AZN241MPGv Air Inc · Medford, ORN24287J B C Development LLC · Evans, GAN24293Digitalev LLC · Westminster, CON2429RJones Adam · Fairbanks, AKN242TC182 Flight Corp · Bronx, NYN242WBUnited States Department Of Interior · Boise, IDN24301Pacific Coast Cycle Corp · Kings Beach, CAN2430QBeavercat Air LLC · Myrtle Point, ORN2440PN2440p LLC · Seattle, WAN2440VVehrs Roger K · Roseburg, ORN2441GTognoli Stefano F · Union, ORN2441YTag Aviation LLC · Santa Teresa, NMN2446ESugarloaf Air LLC · Wilmington, DEN244MEEagle Forestry Services Inc · Monticello, ARN24507Pena Jairo · Catharpin, VAN24518Fly Arkansas LLC · Harrison, ARN2451A722jc LLC · Tyler, TXN2451YSalmon Michael J Trustee · Albuquerque, NMN2455XRucker Aviation Logistics Inc · Shingle Springs, CAN24569Pt Logistics LLC · Rye, NH
Back to Cessna T206H