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 ('9810150')
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 ('9810150')
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.
N101GMBlack Forest Soaring Society · Elbert, CON103PWN103pw LLC · Cumming, GAN104BDLappin Thomas · Austin, TXN104PWBloch Jeffrey J · Santa Fe, NMN105PWTuckey Patrick L · Waxahachie, TXN105USLarson Christina Trustee · Minneapolis, MNN106PWMcknight Thomas N · Fredericksburg, TXN107TPBlack Forest Soaring Society · Monument, CON108JFFreeman James E · Arlington, TXN108PSTexas Soaring Association Inc · Midlothian, TXN112PWVan Tassel Gary W · Seaford, VAN115LCLow Country Soaring Association · Ridgeland, SCN123PWHutnick Michael C Jr · Bloomsburg, PAN123URAerodrome Services LLC · Maple Park, ILN125PWTexas Soaring Association Inc · Midlothian, TXN136PWTexas Soaring Association Inc · Midlothian, TXN147PSFreeman William S · Naperville, ILN157AJPuget Sound Soaring Association · Enumclaw, WAN197HBKhan Asad U · Austin, TXN197PWLouisville Soaring Club Inc · Lexington, KYN202LWPorterfield Robert D · St George, UTN205PWStoyanov Nikolay S · Jersey City, NJN314GEWindy City Soaring Association · Hinckley, ILN32PWGoranson Edwin H III · Durango, CON341PWSoaring Science Inc · Wilmington, DEN35PWBetz James G · Meadowbrook, PAN382RGTucson Soaring Club Inc · Phoenix, AZN410PWChilhowee Soaring Association Inc · Benton, TNN4373KMcleroy Johnathan David · Saint Cloud, FLN4414WZivley Mark · Houston, TXN448RSWhite Wings Soaring Inc · Mount Prospect, ILN465PWTidewater Soaring Society Inc · Windsor, VAN500JNTucson Soaring Club Inc · Sahuarita, AZN505CCSkyline Soaring Club Inc · Front Royal, VAN515DDHarrigan Bernard J · Fontana, WIN523PWTidewater Soaring Society · Windsor, VAN529PWCentral Ms Soaring Society LLC · Brandon, MSN555MWSky Soaring Inc · Hampshire, ILN555PWTexas Soaring Association Inc · Midlothian, TXN598PWFriends Aviation Inc · Wilmington, DEN5XUBobiak James R · Deary, IDN6377XPrairie Thermals LLC · Brookings, SDN705JDCunningham James R · Hopkins, MNN717PWHerr Gary B · Seminole, FLFirst renewal noticeN76DJMississippi State University Soaring Club · Mississippi State, MSN80MGSharp John E · Salome, AZN908BTHutnick Michael C Jr · Bloomsburg, PAN9186GDennis Polen Aviation Educational Foundation · Granbury, TXN927PWStephens Jason L · Maricopa, AZN961JHGacki William L · Mendota Heights, MN
Back to Pzl-Swidnik PW-5