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.
N3639JPrima County Community College · Tucson, AZN3640JCovington Brian · Florence, ALN3644JBoggs Dilan · Nicholls, GAN3646JRegistration Pending · Cornelius, NCRegistration pending, pending cancellationN3650JPostle Jessica Grace · Newark, OHN3652JJet Boy LLC · Carlsbad, CAN3653JGrachev Timofey · Hammond, WIN3656JLofland Aviaiton LLC · Moscow Mills, MON3658JBernbeck Alan R · Benton, KSN3659JHenderson Mark A · Duluth, GAN3662JDeninger William J · Northbrook, ILN3666JKoseogle Ali Ozan · Longmeadow, MAN3667JAbbruzze Michael J · Boynton Beach, FLN3668JBrown Richard C · Adrian, MIN3671JAndrosky Charles S Jr · Superior, WIN3672JOndrasik Peter P Jr · Palmerton, PAN3674JAviation Trust Company LLC Trustee · Oklahoma City, OKN3675JHarder Ronald E · Bell, FLFirst renewal noticeN3676JKorinko Seana L · Rostraver Township, PAN3678JMorgan Daniel W · Keene, TXN3681JPence Northwest Aviation LLC · Salem, ORN3683JGuess Clayton L · Bushnell, FLN3685JBranson David F · Tucson, AZN3686JSeasun Aviation LLC · Miami, FLN3687JPacific Northwest Aeronautics Inc · Lewes, DENon-citizen corporation, flight hours not reportedN3689JInnovative Restoration Aviation LLC · Slidell, LAN3690JMcvay Joshua J · Longmont, CON3691JS & S Aircraft LLC · Rathdrum, IDN3698JWise Tammy B · Eden, NCN3699JBlock Time Bandits LLC · Boise, IDN3700JOluoch Bill Rachuonyo · San Francisco, CAN3702JMaslovsky Serhiy A · Carbondale, ILN3703JSilver And Associates LLC · Ojai, CAN3708JBormann Wayne T · Valley Center, KSN3709JBoughter William C · Port Townsend, WAN3718JStewarts Aircraft Service Inc · Waynesville, OHN3719JVink Ray · Phoenix, AZN3723JKerns Kenneth E · Collinsville, OKN3727JAerowood Aviation LLC · Monroe, NCN3728JSpo Aviation LLC · Eufaula, OKN3734JTrue Course LLC · Honolulu, HIN3735JPetersen Kenton D · Jefferson, SDN3740JHersom Jeffrey T · Helena, MTN3741JSharp Ruth · Clarksville, TNN3742JLow Cost Flying LLC · Chandler, AZN3746JCrandall Lloyd G · Lake City, MIN3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingN3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeN3750JEagle East Aviation Inc · North Andover, MAN3752JLudwig Daniel C · New Rockford, ND
Back to Cessna 150G