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.
N6415SJohnson Edward A · Columbia, SCN6416SCerny Mark V · Canyon City, ORN6421SKnutson Wayne R · Thompson, NDN6423SBores Scott J · Huron, OHN6424SAnderst Waldemar A · Lewiston, IDN6426SGrothe Daniel L · Paynesville, MNN6433SDandrea Robert · Portage, PAN6435SCarney Paul P · Massena, NYN6437SFiresheets William R · Zwolle, LAN6439SKarren Alexander M · Herriman, UTN6444SKiser Douglas D · Schererville, INN6454SLorance Glenn E · Iola, TXN6456SBecker Richard Keith · Fraser, MIN6462SRoss Mitchell B · Ledyard, CTN6467SFenton Harry L · Rhome, TXN6468SMorse Timothy W · Erie, CON6469SWeber Worldwide LLC · Cedar Rapids, IAN6473SUlman Gary T Trustee · Mountain Iron, MNN6477SJuhl Aviation LLC · Luverne, MNN6480SKline James R · Kokomo, INN6483SBlue Skies Aviation Of Wi Inc · Pulaski, WIN6487SSouth Louisiana Community College · Lafayette, LAN6500SSpitfire USA Ltd · Rockville, MDN6502SPetrosyan Joseph · Rancho Cordova, CAN6503SElite Fleet Jacksonville LLC · Jacksonville, FLN6511SGby Aero LLC · Cocoa, FLN6512SHaskin Jeff · Sulphur Springs, TXN6515SMoroney Richard D · Mc Grath, MNN6516SLee Robert E · Medford, WIN651EFGrizzly Air LLC · Clearwater, FLN6520SHighfield Carey · Vanceburg, KYN6522SAlicandro Mark B · Sebastian, FLN6527SHirkala Ronald R · New Cumberland, WVN6529SDemott Steve · Covina, CAN6531SHatcher Mark F · Aloha, ORN6535S315 Flight Club LLC · Fulton, NYN6536SSohr Brian S · Oconto, WIN6540SHalverson Jan T · Goldendale, WAN6541SBurke Frank E Jr · Scotland, SDN6547SMiller Bradley J · Joliet, MTN6548SDersch Jonathan D · Mullica Hill, NJN6553SRegistration Pending · Coeur D Alene, IDRegistration pendingN6556SPflederer Raymond F · Sturgeon Bay, WIN6558SVan Bavel Ethan G · Soldotna, AKN6559SReichelt Harvey R · Ossian, INN6560SClemons Mark T · Bullhead City, AZN6563SPendley Terry · Carbon Hill, ALN6568SBell Daniel M · Mc Alpin, FLFirst renewal noticeN6569SSawicki Victor · Columbus, MIN6570SAnderson Christopher D · Newark, OH
Back to Cessna 150H