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 ('2071826')
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 ('2071826')
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.
N7471GKyle Allyn B · Snohomish, WAN74ALDavis Tessie · Buckeye, AZN7505GRandall James E · Villa Park, CAN750PHTobon Alexander J · Daphne, ALN7510GBoh Air Corporation · Jenks, OKN7515GFrisbee Alice Molnar · Port Charlotte, FLN7517GDecember 1944 LLC · Las Vegas, NVN7529GRibeiro Marcos F · Okeechobee, FLN7533GSiess Tye G · Hot Springs, ARN7560GGreen Carl S · Crivitz, WIN763PAComputer Services Inc · Yukon, OKN7649GSipes Aircraft LLC · Livingston, TXN7657GDodd Brian G · Mount Vernon, SDN7675GHalopoff Guy · Oroville, CAN7690GScott Kyle J · Fort Morgan, CON7730GSellet Jack A · Winter Haven, FLN7735GShaver John M · Shelby, NCN7748GSchilling Erik D · Cumming, GAN7756GDedalis Emory A · Colts Neck, NJN77PPBloom Jonah M · Palmer, AKN7814GClayton Steve · San Anotonio, TXN7827GFlying Falkor LLC · Bellevue, WAN787JABole David M · Auburn, WAN7883GPhillips Douglas C · Ephrata, PAN7927GUrban Aviation Services Inc · Paxton, MAN7930GRaney Wayne L · Hoxie, KSN7932GDs Flight Services LLC · Battle Ground, WAN7933GGenzman Dennis W · Tucson, AZN7952GPlunkett Charles K E · Eagle Point, ORN7953GSnyder Kenneth C · Lonsdale, MNN7987GHigh Expose Inc · Woodbine, NJN7AABolyard Norma · O Brien, FLN8082MKeenan Thomas E Jr · Smyrna, DEN8131LGerber Aviation LLC · Winter Haven, FLN8162MMeggers Darin R · Baker, MTN826XHHoleman Darren C · New Town, NDN82EDRodriguez Rolando · Harlingen, TXN861TWTailwinds LLC · Ewing, NJN88GMField Drew H · Dallas, TXN9047GOdd Dale R · Aberdeen, WAN9167CNew Garden Township · Landenberg, PAN935CBCalifornia Baptist University · Riverside, CAN9365MFiglia Emanuele · Lewes, DEN9430MKruschwitz David A · Anchorage, AKN98BVUSA Air LLC · Ruskin, FLN994JPHinen Paul H · Soap Lake, WA
Back to Cessna 150L