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 ('2071818')
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 ('2071818')
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.
N6757SLoya Francisco · Crestline, CAN6760SPantera Services LLC · New York, NYN6762SRegistration Pending · Snowflake, AZRegistration pendingN6765SMaxson Gerald · Hawthorne, FLN6774SBennington Aaron G · Delaware, OHN6777SEhrhardt Paul R · Junction City, ORN6785SSchmidt Gary C · Sunrise Beach, MON6790SHildreth Jon R · Spencer, WVN6792SJohnston Robert G · Rose Hill, KSN6796SRegistration Pending · Lawrence, KSRegistration pendingN6799SAdr Aircraft Service Inc · Burbank, CAN685RADenkat Plane Shadow LLC · Buckeye, AZN68FTFat Tire Aviation LLC · New Bern, NCN6903SSchewe William · Greenville, ILN6904SKoller Rex E · Athens, ALN6905SSwanson David L · Rolling Meadows, ILN6911SHodges John Wesley · Chesapeake, VAN6915SCochran William J · Williamson, GAN6917SFly 17 Sierra LLC · Tampa, FLN6923SEpley Kennith W · Ladonia, TXN6927SCendejas Agustin · Chino, CAN6928SPoling Brett Tyson · Saint Francis, KSN6934SLet There Be Flight LLC · Portage, MIN6937SCaum David A · La Porte, INN6941SBrowning Stephen D · Bear, DEN6943SBoniek Martin J · Nederland, CON6944SVfr Aviation LLC · Clayton, NYN6946SImage Aviation Services LLC · Wilmington, DEN6948SZaremba Michael W · Custer, WIN6952SMyers Karen J · Bemidji, MNN6954SPierson Jared · Coeur D Alene, IDN6955SHhd Aviation LLC · Hamilton, OHN6958SPeterson Leonard J · Cleveland, TNN6965SSawyer Donald · Johnson, VTN6966SStout Larry E · Winamac, INN6968STrue Robert S · Prosper, TXN696NSParkhill Clifton A Jr Trustee · Oxnard, CAN6971SHirsch T W III · Farmers Branch, TXN6976SMancine Timothy J · Turner, MEN6981SSalerno Gina · Cape Coral, FLN6986SKass Deborah J · Chandler, AZN6987SHubbard Broadcasting Inc · Saint Paul, MNN6995SNaylor Aviation LLC · Scotch Grove, IAN6998SFowler John C · Scott Depot, WVN7006SSpicer Greg · Portage, MIN7007SJw Air Ventures LLC · New Smyrna Beach, FLN7008SPoe John B · Port Orange, FLN7016SCreed Stephen L · Hamilton, VAN7017SGladwin Stephen R · Pflugerville, TXN7021SMountainhawk Leasing LLC · Nampa, ID
Back to Cessna 150H