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 ('21101P3')
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 ('21101P3')
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.
N6316NLeyes Richard A II · Janesville, WIN6317NMorton David J · Brooks, GAN6338NCole Justin L · Mendon, NYN6343NHenderson Scott · Cocoa Beach, FLN6345NColeman Darryl W · Fayetteville, GAN6362NGoodwin David C · Boulder, WYN6365NSouth Dakota State University · Brookings, SDN6369NEberhart Royce R · Covington, GAN6378NSilent Sea Acres LLC · Beaver Dam, WIN6389NLedbetter Jason · Ypsilanti, MIN6393NCulpeper Aviation LLC · Queen Creek, AZN673JFHall Matthew P · Fowlerville, MIN69AUThoma George E · Old Lyme, CTN7500FGrindley John E · Hopewell Junction, NYN7526FMikulich Joseph · Bovey, MNN7531FCanale Anthony · Friendswood, TXN7532FPrather Carl L · Gilroy, CAN7544FGrundy James W · West Greenwich, RIN7546FPutman James G · Guntersville, ALN7561FRivers Robert A · Oxford, NCN7563FPayne Jimmy D · Newnan, GAN7567FMansfield Heliflight Inc · Milton, VTN7570FReichelt Christopher M · Mocksville, NCN7572FKinder Mark E · Scottsdale, AZN7589FAerial Advertising Services · Livermore, CAN7600FGiles Forrest D · Springtown, TXN76BEBrown Darrell W · Covington, GAN787SWSpringfield Flying Service LLC · Columbia, CAN847DLHoppe Joel A · Mankato, MNN85CSeay Edward A · Signal Mountain, TNN869TTDimond Joan M · Birch Run, MIN8888NGibson Edward J · Marmora, NJN9008LP And C Flying Club LLC · Williamsport, PAN9011LLussier John A · Greene, RIN9044LAzzalin Giorgio · Jacksonville, FLN9045LSalter Christopher D · Elberta, ALN9055LJavelin Citrus LLC · Erda, UTN9064LHendrickson Don W · Helena, MTN9069LCitabria Flyers LLC · North Salt Lake, UTN9077LVeilleux Payton L · Pittsfield, VTN9080LStewarts Aircraft Service Inc · Waynesville, OHN9083LPeavy Michael J · Chico, CAN9102LCook James C · Auburn, ALN9104LKalman Engineering Inc · Pekin, ILN9112LRockey Bruce G · Bitely, MIN9129LOsi Flyers Inc · Oak Ridge, TNN9171LBrolan Aviation LLC · Kansas City, MON929ACWitman Michael R · Milliken, CON93BYPearce Ricky A · Parsons, KSN9712NKeller Gerald C · Kokomo, IN
Back to Champion 7KCAB