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 ('2072434')
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 ('2072434')
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.
N733WMNakamura Hajime Trustee · Long Beach, CAN733WSAirgo Inc · Centralia, ILN733WTAnderson Aviation Services Inc · Carlsbad, CAN733WUAviator Air Flight School LLC · Grand Prairie, TXN733WVRatzlaff Jeff DBA · Langdon, NDN733WWFm Aviation Inc · Concord, CAN733WXSpartan Marine Co · Capistrano Beach, CAN733WYFlys And Floats C172 LLC · Panama City Beach, FLN733XBBlair Burkholder Inc · Erie, CON733XDRoadrunner Bus LLC · Weston, NEN733XEAeroventures Flying Club Inc · Lilburn, GAN733XFBeaugez Gregory C · Perkinston, MSN733XKSabol Edward J Trustee · Leominster, MAN733XLAirspeed Marketing LLC · Phoenix, AZN733XMRoatis Calin V · Sacramento, CAN733XNFlyn Go LLC · Spring, TXN733XXHann Bruce E · Athens, OHN733XYRuss Micheal · Greer, SCN733XZ3650 Aircraft Inc · Bakersfield, CAN733YBZulu Aerospace Services LLC · Peoria, AZN733YCWings Over Texas Holdings LLC · Denton, TXN733YEDiederich Fred H · Fayette City, PAN733YGLeaschauer Eitan · San Jose, CAN733YHBailey Gordon J · Fayetteville, GAN733YKLdac Properties LLC · Fresno, CAN733YPMiller Robert · Battle Creek, MIN733YRBoccaccio Donald O · Hypoluxo, FLN733YTRegistration Pending · Centereach, NYRegistration pendingN733YVSluka Christopher J · San Diego, CAN733YYTetrault Howard D · Malabar, FLN733YZSeaplane Adventures LLC · Cheyenne, WYN733ZAWanda Collins Professional Pilot Services LLC · Madisonville, TXN733ZBMidstate Aviation 1 LLC · Owosso, MIN733ZEKgr Aviation LLC · Austin, TXN733ZGContreras Shelly · Tracy, CAN733ZKStone Aviation LLC · Sacramento, CAN733ZNAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAN733ZPFruit Belt Flyers Inc · Saint Joseph, MIN733ZSMccown Jamey · Bayfield, CON733ZYHess Garrett J · Fullerton, CAN733ZZDuncan James · La Porte, TXN734ACRich Lucas Aircraft Sales LLC · Lincoln Park, NJN734AEFlight Club 502 Inc · Louisville, KYN734AHAnderson Zachary Q · Rudyard, MTN734AMGlobal Flight Training Solutions Inc · Immokalee, FLN734AQBarrans Daniel L · Glenmoore, PAN734ASStory Larry W · Double Oak, TXN734AULeading Edge Aviation Inc · Doylestown, PAN734AXPenel Aviation Corp · Baldwin, NYN734AYRico Aviation Services Inc · Miami, FL
Back to Cessna 172N