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 ('2071830')
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 ('2071830')
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.
N63610Frantz Paul · Palmyra, PAN63617Johnston Daniel · Virginia Beach, VAN63619Beard Jeffrey L · New Oxford, PAN63620Florida Airplane Recovery LLC · Tallahassee, FLN63621Macgregor Sinclair · Oroville, CAN63626Nelson Matthew J · Frewsburg, NYN63632Prestige Air Charter Inc · Sandston, VAN63637Oclair Justin B · New Canada, MEN63641Cole Warren G · Watkinsville, GAN63645Greene Roswell J · Punta Gorda, FLN63646Reed Phillip · Lanesboro, MNN63647Appalachian Wings LLC · Ellijay, GAN63650Crain Charles E III · San Antonio, TXN63651Agricola Joseph D · Brooksville, FLN63652Tyndall Darryl K · Deep Run, NCFirst renewal noticeN63653Coker Steve L Jr · Tyler, TXN63655Van Houten Ronald G · Kalamazoo, MIN63657French Chris · Anchorage, AKN6365KSchlueter Wayne J · Andover, KSN63662Gessert Adam K · Gilbert, AZN63664Cabrera Ramon F · Guttenberg, NJN63665101 Flight LLC · Waterford, MIN6366KCastano Jose R · Sleepy Hollow, NYN63670Uflyorlando Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN63671N63671 LLC · Austin, TXN63677Weir Ryan Lee · Buckley, WAN63679Goldman Jacob · Bend, ORN6367KPethes Ted · Las Vegas, NVN6383KMock Joseph R · Huntsville, TXN6406KWandell Daniel J · Murfreesboro, TNN6408KShowah Michael F · Scottsdale, AZN6414KLindberg Joseph J · Chugiak, AKN6416KShreveport Aviation Services LLC · Shreveport, LAN6422KOvist Gregg · Phoenix, AZN6424KAirgo Inc · Centralia, ILN6425KRegistered aircraftN6454KFlying Aces Aero-Fleet Inc · Guyton, GAN6455KFlying Gators Inc · Overland Park, KSN6457KWysong Henry D III · Kent, WAN6469KPolley Val D · Tucson, AZN6474KDavis Thomas Aviation Group LLC · Saint Martinville, LAN6479KHall Charles R · Greenbrier, ARN6482KKimmel Timothy I · San Angelo, TXN6491KFisher Air LLC · Cardington, OHN6495KBauknecht Daniel P · Antigo, WIN66022Pickett Ronald K II · Mc Alpin, FLN66042Hudson Steven E · Junction City, KSN66047Shiles Darrell J · Baltimore, MDN66054Wooten Jeffrey B · Rock Hill, SCN66055Tas Aviation Aircraft Sales LLC · Defiance, OH
Back to Cessna 150M