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 ('2071816')
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 ('2071816')
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.
N3753JWallin Joshua M · Moreno Valley, CAN3756JLong Donald R · Seneca, SCN3760JWeeks Ryan A · Sneads Ferry, NCN3765JSatanta Flying Service Inc · Satanta, KSN3767JHalbur Wesley D · Heron Lake, MNN3768JWheeler Kevin M Trustee · Comstock Park, MIN3769JRatner Robert D · Swan Lake, NYN3770JAzad Raja M · Hawthorne, CAN3771JKozel Thomas · Pottstown, PAN3773JBertrand Aviation LLC · Brookville, KSN3781JSantonocito John A · Bradenton, FLN3784JMilbourn Edward M · Greenfield, INN3793JMccoy Michael B · Colbert, WAN3799JGiger Michael R · Slater, MON3801JSchomberg Coby D · Washington, MON3804JBranagh Charles J · Clay, NYN3811JWright Wayne M DBA · Chestertown, MDN3813JWinnie Daniel R · Seattle, WAN3816JJames Randy C · Knob Noster, MON3818JAyresouth Aviation Inc · Lithia Springs, GAN3824JBalcsik Christopher A · Tehachapi, CAN3827JCollins Camden B · Millersport, OHFirst renewal noticeN3834JRegistration Pending · Buckeye, AZRegistration pendingN3835JSkylane Lift LLC · Cheboygan, MIN3843JN3843j LLC · San Antonio, TXN3847JEscue James C · Brownsville, TNN3849JGamble Marty · Crofton, KYN3855JWiley Phillip W · New Martinsville, WVN3856JClifton Chad R · Asheboro, NCN3859JOnefiftyjuliet LLC · Saint Petersburg, FLN3862JDoyle Ethan Mackenzie · Nunda, NYN3865JAlbert Bruce F · Dallas, TXN3867JOmura Alexander K · Missoula, MTN3870JLucido Frank · Vacaville, CAN3877JWilson Steven J · Elkton, KYN3879JMuehl John M · Maryland, NYN3882JPeek James · South Fork, CON3888JAzalea Aviation LLC · Quitman, GAN3889JVeduccio Gary Robert · Griffin, GAN3896JKhatz Rahm · Austin, TXN3901JHolladay Leonard · Greeley, CON3902JUltimate Aviation LLC · Lowell, ARN3908JSpanaflight LLC · Puyallup, WAN3910JNishikawa David H · Davis, CAN3913JGecsey Sandor · Budd Lake, NJN3916JTrimble Aviation Services LLC · Atlanta, GAN3918JPegasus Horse LLC · Las Vegas, NVN3922JPettit Thomas N · Whitestown, INN3924JRagsdale Ryan J · Hemingford, NEN3935JMcdonald Patrick L · Ventura, CA
Back to Cessna 150G