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 ('2072724')
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 ('2072724')
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.
N3016QBarnes David L · Palmer, AKN3018QAndre Eric J · Somerset, WIN3019QHatfield Brothers LLC · Gooding, IDN3021QPicco Anthony · Sykesville, MDN3026QSuper D Group LLC · Hanoverton, OHN3028QAllenspach Timothy L · Stillwater, MNN3029QOzarks Auto Show Inc · Hollister, MON3032QMitchell Michael A · Old Forge, NYN3033QFisher David E DBA · Bristow, OKN3036Q3 Rivers Airshare Llp · Sheridan, MTN3037QState Of Arizona · Holbrook, AZN3043QDerango Gregory J · Chitina, AKN3044QParrow Ronald J · Hampton, CTN3045QLong Randy B · Coleman, TXN3046QN3046q LLC · Colorado Springs, CON3047QWiechmann Michael D · Friendswood, TXN3048QBad Eagle Aviation LLC · Fulshear, TXN3057QJoseph C Casey · Lufkin, TXN3060QYarg Tap LLC · Midland, TXN3065QSuchy Michael R · Murrieta, CAN3066QMeyer Vernon C · Westlake, LAN3069QMarin Alberto · Mc Neal, AZN3071QNichols Waylon · Copeland, KSN3074QGriffin John O · Driggs, IDN3075QDickerson Anthony S · San Tan Valley, AZN3080QN3080q LLC · Phoenix, AZN3082QAttaalla Maged A · Torrance, CAN3087QBellas Business LLC · Kalispell, MTN3088QRosenblatt Jeffrey A · Portland, MEN3089QBrotnov Jerald W · Clarkston, WAN3091QDank Noah S · Jacksonville, FLN3093QLitton Wade N · Townsend, MTN3094QSunrise Property Maintenance Inc · Sandy, UTN3096QMorgan County Aviators LLC · Fort Morgan, CON3100RCentral Oklahoma Aviators Flying Club · Piedmont, OKN3103FJorgensen Bryan K · Kingston, GAN3104QSauer Jason DBA · Glen Ullin, NDN3106QStiens Fred T · Moses Lake, WAN3107QWest Valley Aviation Inc · Five Points, CAN3108QSipe Thomas L · Rhome, TXN3109QWellink Jos · Katy, TXN3113QTj Enterprises LLC · Stayton, ORN3114QBaird Steven L · Chapel Hill, TNN3115QThomas Charles S · Barstow, CAFirst renewal noticeN3118QVercoe Trevor · San Clemente, CAN3120QLinda In The Sky LLC · Webster, MNN3123QDarkhorse Six Inc · Boerne, TXN3125QSunrise Aviation Llp · Gig Harbor, WAN3128QK Bell Enterprises Inc · Columbia Falls, MTN3129QUrbanowski Edward F · Paxton, MA
Back to Cessna 182K