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.
N3937JWolsey Brandon S · Chino Hills, CAN3938JPlainwell Aviation And Stem Academy · Kalamazoo, MIN3939JMidwest Aero Solutions LLC · Lake Saint Louis, MON3940JJess Lawrence A · Menomonie, WIN3951JJenani Industries LLC · La Verne, CAN3952JStewarts Aircraft Service Inc · Waynesville, OHN3953JKearns Reno T · Jeannette, PAN3954JDroessler Anthony E · Lakota, IAN3955JLaird Charles L · Adelanto, CAN3956JStriplin James R Jr · Hartford, ALN3957JMckinnon Benjamin G · Santaquin, UTN3959JBergin Aire · Shelter Island, NYN3962JKrnavek Carl R · Dayton, TXN3966JLee A Archer Jr Red Tail Youth Flying Programs Inc · New Windsor, NYN3967JAbbott Cedric M · Buckfield, MEN3968JFlying Forward LLC · New Carlisle, OHN3969JKhleb Hub LLC · Palm Coast, FLN3980JMushrush Kim · Tarrytown, GAN3981JKruger Gerhard B · Lathrop, CAN3983JVoizin Thomas J · Toney, ALN3984JMatta Figueroa Eduardo · Chapman, KSN3985JS & S Aviation LLC · Roanoke, INN3987JRegistration Pending · Wylie, TXRegistration pending, pending cancellationN3988JTorrini Donald G · Edwardsville, ILN3992JSabin Ronny L · Kennewick, WAN3993JWegner Eric E Trustee · Oconomowoc, WIN3995JWoodstock Air LLC · Monticello, FLN3996JThorman Joseph · Moorhead, MNN3999JMurphy Arthur John III · Huntsville, ALN399TXCherry Lane R · Vidor, TXN4006JGreenstreet Robert A · Lake Geneva, WIN4013JMacomber Daniel · Chehalis, WAN4019JPowell Edward H · Potsdam, NYN4021JSharapan Ilya · Brooklyn, NYN4023JHector Flyers LLC · Hector, MNN4027JMcburney James H Jr · Horseshoe Bay, TXN4028JWarn James D Jr · Overland Park, KSN4034JStange Robert C · Toledo, OHN4035JBloomquist Steven R · Granbury, TXN4043JDevine Steven A · Roseville, CAN4044JLiberty University Inc · Lynchburg, VAN4049JWashington Aero Club Inc · South Park, PAN4055JStrobel Oliver K · Fishers, INN4057JTurner Jeremy A · Rancho Murieta, CAN40583Grald Jonathan A · New Hampton, NYN4060JDooley Bob A · Alexander, ARFirst renewal noticeN4061JConley Rocky · Swanton, OHN4063JPoules Alexander · Hope Valley, RIN4067JSkyway Inc · Wilmington, DEN4068JSutton Thomas A · Gaylord, MI
Back to Cessna 150G