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 ('2075816')
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 ('2075816')
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.
N182PDNk Dockside LLC · Escanaba, MIN182PLGonzales Edward · Gallup, NMN182PRWeigle Gerald V Jr Trustee · Cincinnati, OHN182PURdl Aviation LLC · Covington, GAN182PVGoble Robert G · Bellefontaine, OHN182PZSix Nickles Aviation LLC · Macon, GAN182RETri-County Ag Service Inc · Ipswich, SDN182RJFarpointe Aviation LLC · Charleston, WVN182RSGrumpy Petes Aviation LLC · Walla Walla, WAN182SNelson John A · Beverly, MAFirst renewal noticeN182SBKlingaman Russell A · Punta Gorda, FLN182SCMiller Michael C · Coon Rapids, MNN182SGFarm Recharge LLC · Brawley, CAN182SLRobinson Steven A · Sequim, WAN182SSRader Gregory A · Baldwin, KSN182SWRegistration Pending · Henderson, NVRegistration pendingN182SZHigh Wing Aviation LLC · Phoenix, AZN182TBKelly Michael · E Wenatchee, WAN182THStafford Developments Inc · Tupelo, MSN182TMMcmillan Jon V · Newnan, GAN182VZeigler Bradley C · Alexandria, VAN182VCVogeney Andrew D · Phoenix, AZN182VVPlane Envy Aviation LLC · Winter Park, FLN182WFWhiskey Foxtrot LLC · Fort Kent, MEN182WJSchroder Curtis L · Campo, CON182WKKcn Aero Club · Overland Park, KSN182WRBarnes Stephen W · Mustang, OKN182WXTre Aviation Corp · Wilmington, DEN182XN182x LLC · Midlothian, TXN182XPBd Flight LLC · Madison, WIN182YASageeyah Cessna LLC · Claremore, OKN1835MAanonsen Lloyd B · Venice, FLN1836MCallan Donald G · Yulee, FLN1838MGenesis Aircraft Services Of Martin County LLC · Stuart, FLN183CRBekway Builders LLC · Charleston, SCN183NMAfrican Parks Aviation Inc Trustee · Cheyenne, WYN184DPRobertson Gary B · Canton, TXN1876MTracy Peter E · Bishop, CAN1878MUS Sander LLC · Esperance, NYN1885MLittle Dog Aviation LLC · Anchorage, AKN1891MStarkman Timothy S · Monterey, CAN1899MLoki Adventures LLC · Norwood, CON18ADEzs Flyers LLC · Bonduel, WIN18ZPPierce Lestley R · Henderson, NVN1908MAirtrader LLC · Hornersville, MON1910MMob Aviation USA LLC · Auburndale, FLN1916Rauser Richard A Trustee · Cottonwood, CAN1918MWalker Stephen L Trustee · Andover, KSN1920MThompson William F · Fisherville, KYN1921MRed Shirt Resources LLC · Weatherford, TX
Back to Cessna 182P