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 ('2071822')
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 ('2071822')
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.
N6055GStuckey Carl W · Collinsville, OKN6058GKowalis Christopher C · Katy, TXN6059GBishop Elijah N · Montgomery, TXN6060GPrimo Haim · Fredericksburg, VAN6061GJohnson Victor R · Modesto, CAN6066GGisselman Scott D · Lago Vista, TXN6067GWildroot Aviation LLC · Bellingham, WAN6068GWilliams Daniel E Jr · Morehead City, NCN6070GSimpson Michael · Chateaugay, NYN6075GTango Aviation Rentals LLC · Austin, TXN6076GColbert Farms Inc · Davenport, WAN6088GGreat Lakes Air Ventures LLC · Mason, MIN6091GAkin Evrin · Newport Beach, CAN6092GComeau Charles · Brimfield, MAN6093GCaylin LLC · Wilmington, DEN6096GPilot Pros Inc · Miami, FLN6100GEvent Tech Services LLC · Quarryville, PAN6107GRhea Koy A · Annona, TXN6108GPetrov Konstantin P · Hallandale, FLN6110GHigh Exposure Inc · Wilmington, DEN6113GPratt Aviation Services Inc · Anchorage, AKN6116GWilbur David W · Marlow, NHN6121GMckinney Christopher D · Statesville, NCN6123GBoes Corey · Fostoria, OHN6129GPeters William E · Bel Air, MDN6131GCragg Gordon E · Georgetown, TXN6137GPiersol Benjamin T · Honey Brook, PAN6138GStrange Keith · Lincoln, MEN6140GSmoketown Flight Center LLC · Smoketown, PAN6143GSale Reported · Brodhead, WISale reportedN6144GHoke Christopher R · Kernersville, NCN6150GStockton Raymond L · Pearl City, HIN6154GGrinnell Matthew J · Auburndale, FLN6155GChin Benny C · Chandler, AZN6161GGough James L · Hesston, KSN6165GPartida Carlos · Delray Beach, FLN6169GKingdom Air Corps · Sutton, AKN6171GMission Flight Academy · Yucaipa, CAN6172GTappan Scott M · Port Saint Lucie, FLN6174GMosley Gabriel T · Oak Hills, CAN6185GJuel Thomas Gavin · Everett, WAN6187GMiller George Chris · Lone Oak, TXN6189GBrule Alan R · Crookston, MNN6193GHolcomb Jonathan Michael · Hollandale, MSRegistration expired, pending cancellationN6199GPerez Joseph F · Hollywood, FLN6201GOlson Christopher L · Delavan, WIN6208GWilson Tom P · Ontario, CAN6210GJm Pop LLC · Queen Creek, AZN6215GSkagit Airport Eaa Chapter 818 · Shoreline, WAN6220GDuncan Paul J · Bartlett, TN
Back to Cessna 150K