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 ('7100510')
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 ('7100510')
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.
N2210MMeal Gary R · Roanoke, INN2211MSloyer Matthew · West Chester, PAN2215MGonzales Donald M · Columbia Station, OHN221NJKowall Stephen J · Elgin, ILN2223MWilliam Irving Warren · Parsonsburg, MDN2224MLewis John E · Clayton, NJN2226MMalone Bernard G · Frenchtown, NJN2228MRoberts Marvin L · Calhoun, GAN2229MJohafe Aviation LLC · Wilmington, DEN222NBarber William A II · Newmarket, NHN2234MHodge Anthony W · Quinlan, TXN2235MSmith Amber V · Muscle Shoals, ALN2236NWhitehouse Carol H · Vero Beach, FLN2238MMayers Nathan A · Ashland, VAN22394Roberts James A Jr · Hamburg, ARN2242MHatton Frederick L · Dover, NHN2246MSmith James A III · Millerton, NYN2248MWhite Anthony · Orange, VAN2252MRevoir Scott R · Hastings, NYN2263MBeene Kenneth E · Waco, TXN22705Reeve Howard E · Minot, NDN22726Klug Wayne Allen · Trout Run, PAN22733Snell Robert B · La Vernia, TXN22745Currie Richard W · Woodland, CAN2274VSturges David I · Boring, ORN2278MBergstrom James W Jr · Kapolei, HIN22804J3 Cub Club LLC · Simpsonville, SCN22831Livingston Daniel C · Pratt, KSN22861Turner Lee H · Felton, DEN22875Lowe Anthony E · Edina, MNN22908Endthoff Wayne K · Beloit, WIN22946Alsup Alan D · Gainesville, TXN22951Horst G Marlin · New Holland, PAN22973Bowe Walter C Trustee · Sonoma, CAN22978Tre Aviation Corp · Queen Creek, AZN22EFJordan Scott A · East Falmouth, MAN22WTGarcia Roberto P · Spring Hill, FLN23100Zielinski Dustin K · Salem, ORN23115Scaletta Samuel L · Middleton, WIN23126Consag LLC · Ainsworth, NEN23145Mcwilliams Tyler C · Rawlins, WYN23146Davis Trenten E · Brodhead, WIN23151Winsors Wings LLC · Rogersville, MON23166Blue Sky & Tailwheels LLC · Mary Esther, FLN23249Bivens Jason D · Duncan, OKN23266Vautin John Trustee · Thousand Oaks, CAN23283Property Data Systems Inc · Dawsonville, GAN23288Raw Racing Inc · Puyallup, WAN23289Jb West Aviation LLC · Dumas, ARN23297Nelson Stephen W · Gig Harbor, WA
Back to Piper J3C-65