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 ('2073449')
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 ('2073449')
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.
N59008Davis Burton D · Jefferson, IAN59011Nelson Albert N III · Baytown, TXN59041Edwards Aviation & Consulting LLC · Broken Arrow, OKN59045Air-Zancada Inc · Wilmington, DEN59049Scarry David Charles · San Luis Obispo, CAN59173Vogelgesang Randy · Gardnerville, NVN59258Energy Roofing Technology Se LLC · Lake City, FLN60636Allard Michael L · Penrose, CON61170Rusty Pilot Holdings LLC · Citrus Heights, CAN611WSFreedom Flight Service LLC · Glendale, AZN61275K & K Adventures Inc · Wilmington, DEN6139BFelker Gary L · Odessa, TXN6677RTre Aviation Corp · Wilmington, DEN66CEM&S Real Estate Management Inc · Granbury, TXN699EEMathes Jay B · Ridgecrest, CAN710TDDuke Ray J · Oak Point, TXN717DKRegistration Pending · North Las Vegas, NVRegistration pendingN71WTBear Cat Air LLC · Gun Barrel City, TXN722PDW O Zangger And Son Inc · North Loup, NEN732ADDavis Billy E · Castlewood, SDN732AQGold Star Air · Portland, MEN732BASparks Steve · Hamilton, OHN732BBBishop Thomas W · Decatur, TXN732BKJones Mark A · Johnson City, TXN732CBAire Flight Systems Inc · Midwest City, OKN732CRGlobal Energy Werks LLC · Ely, MNN732CXEvans Terry W · Corning, IAN732DKMckay Donald E · White City, ORN732DMFlying Knights LLC · Farmington, NMN732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTN732DWKowalczyk Ryan · Boise, IDN732ECPompa Oliver · Tucson, AZN732GK3jc LLC · Phoenix, AZN732HDMgp Investments LLC · Woods Cross, UTN732HKAnderson Milton M · Twin Bridges, MTN732JFSpeed Of Light Aerospace LLC · Lompoc, CAN732JJCj Air LLC · Escondido, CAN732JS732js Partners Ltd · Batavia, ILN732JWSunniland Ranch Airport LLC · Okeechobee, FLN732KBTadco Equipment Inc · Laveen, AZN732KCKing Daddy Aviation LLC · Madison, MSN732KEMcintosh Ian K · Floydada, TXN732TJEscalante Aviation LLC · Boerne, TXN74LCLee County Sheriffs Office · Ft Myers, FLN74MMFief Ron C · Creede, CON755SWMelendez Daniel Alexan · Yuma, AZN75935Allison Aviation LLC · Missoula, MTN75DMPro-Rentals Inc · Athens, OHN75GLSkyshare LLC · Boulder, CON76BLBravo Lima Corp · Lakewood, CO
Back to Cessna T210L