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 ('2073451', '2073452')
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 ('2073451', '2073452')
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.
N6153BCenturion Southeast Management LLC · Raleigh, NCN6161NOn Eagles Wings LLC · Los Gatos, CAN6168NRegistered aircraftN6170NGarmin210 LLC · Willard, MON6174BN6174b LLC · Nokomis, FLN6180BNewton Raymond C Jr · Heath, TXN6180NMargiotta Russell A Trustee · Woodside, CAN6183NLewis A Everett Jr · Chico, CAFirst renewal noticeN6185BGust William J DBA · Monument, CON6195BBoyd Edward Ayres · Coronado, CAN6202BGamache Daniel S · Pleasanton, CAN6211BFleming Patrick J Trustee · Palm Desert, CAN6223BSpirek Aaron M · Henderson, NVN6240BVan Treese Farms Inc · Monte Vista, CON6246BR L Equipment And Services LLC · Monument, CON6276BN6276b LLC · Katy, TXN6282BBig G Air LLC · Durango, CON6303BUpper Valley Aero LLC · Hanover, NHN6314DSaghafi Jamsheed Trustee · Parma, OHN6359BRoss Stout Architect Inc · Indian Wells, CAN6364BKgnf LLC · Grenada, MSN6394DManzur Miguel Antonio · Mcallen, TXN6397BLayson Walter E · Calhoun, GAN6419BMarshall Timothy M Trustee · Tucson, AZN641MRoyo Marco · Canutillo, TXN6436BConway Jenna M · Camarillo, CAN6440BWolfe Transportation Inc · Meridian, IDN6457BJcb Holdings LLC · Helena, MTN6491BTerrill Guy J · Dillon, MTN6492BPatno Delviny A · Daniel, WYN6506VHarper Dreams LLC · New Smyrna Beach, FLN65093Seaman Michael V · Kalispell, MTFirst renewal noticeN6526MDapp Eric M · Corvallis, ORN6557BFangio Mark · Mckinney, TXN6653BWilson Gale E · Lewiston, IDN6677BHess Chad · Boise, IDN6680BBush Douglas B · Santa Rosa Beach, FLN66DFClark Samuel D Trustee · Wilson, WYN66MLBas Part Sales LLC · Greeley, CON6722BJca Aviation LLC · Safford, AZN6779BRegistered aircraftN6816BMystic Dreams LLC · Mount Juliet, TNN6826BDan Howard Aircraft Sales LLC · Tulsa, OKN684MCT&B Aero LLC · Jacksonville, FLN6850BJennings Donald J · Gypsum, CON6870MApplied Science Services Corp · Woodland Hills, CAN6899BCowgill Robert W · Amissville, VAN68BMDavenport Donald · North Las Vegas, NVN6900XMueller Robert C · Reno, NVN6927BKryptonite Industries LLC · Golden, CO
Back to Cessna T210M