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 ('2071812')
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 ('2071812')
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.
N6211TPeterson Troy · Karlstad, MNN6212YHoran Jack F · De Berry, TXN6217RCampbell J R Jr · Bell, FLN6217TTaylor Nathan E · Spanishburg, WVN6218RAnnala John H · Dacula, GAN6219RRegistered aircraftN621MAAnderson Keith R · Norwood, MAN6220TStorey Erik A · Fillmore, CAN6222RBarge And Associates Inc · Houston, TXN6223RBroadwell Eric · Woodstock, GAN6225TMohnacky Robert A · Roscoe, ILN6226RHamman Baron L · Dallas, TXN6227RMidwestern Soaring Assoc · Peculiar, MON6228RMangham Charles H · Mineral Wells, TXN6231RSando Mark T · Carson City, NVN6232RBeavers Benjamin K · Omaha, NEN6232TDavenport Richard B · Danbury, TXN6238TLocklear Benjamin M · Mangum, OKN6239TEvans Cliff D · Boulder Creek, CAN6241TArm 4 Aviation LLC · Blanchard, IAN6242THuff Glenn R · Garrison, MNN6243TStanek Michael K · Palm Bay, FLN6244TAljanabi Mohammed K · Herndon, VAN6245THauck Scott T · Elkhart, INN6248TPierce Donald Ray · Phoenix, AZN6250TWinnett Tommy E · Lexington, NCN6251TKropf Nathan L · Clarksville, ARN6254TNeary John · Ridgefield, NJN6256TYork Randal G · Cullman, ALN625MAScenic North Development Inc · Copemish, MIN6261TGrahn Mark C · Marana, AZN6267TLittleton Roy T III · Ruther Glen, VAN6268TBartkowiak Alex M · Moorhead, MNN6271TBesteiro Aly E · Brownsville, TXN6277TMaier Daniel Edward · Vancouver, WAN6279TCragg Gordon E · Georgetown, TXN627MHappy Kamper Aviation LLC · Austin, TXN6281TSalyer Arthur W · Temecula, CAN6285TReasner David S · Moultonborough, NHN6288TGrote Bradley J · Torrington, WYN628MAFitzgerald Brian B · Gettysburg, PAN6290TLittlefield Molly F · Kent, WAN6292TLee Bryan L · Salinas, CAN6293TFranks Lauren N · La Fayette, GAN6296THillsboro Flying Club Inc · Hillsboro, WIN6297TFrazier Joel A · Fennimore, WIN6299TRegistered aircraftN-number assigned, not yet registeredN642MALittle Bird 150 LLC · Parsons, TNN65MArata Steve · Corning, CAN65RGRandolph Clinton A · Bullhead City, AZ
Back to Cessna 150E