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 ('1151522')
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 ('1151522')
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.
N8257DWhicker Jacob Edward · Willard, UTN8258DMatthew Avionics Testing & Technical Support LLC · Stevensville, MTN8259DBlack Hunter F · Blanding, UTN8261DGrimmett Carl W · Gravois Mills, MON8263DKroll Douglas W · Brighton, CON8265DPreston Jack Aviation LLC · Mesa, AZN8268DSmith Nafis T · Wayne, PAN8272DHenderson Will · Buffalo, SDN8274DLim William Taek · Rancho Cucamonga, CAN8279DBullard Thomas Eugene · Midlothian, TXN8282DHenry Craig A · East Troy, WIN8287DWhite Steven · Oxnard, CAN8293DVeum Todd E · Sault Sainte Marie, MIN8295DHorning Martin R · Lincoln, CAN8297DDunlap Martin L · Hartville, OHN8300DAltitude Adjustment LLC · Solvang, CAN8302DSmith Luke Allbee · Houston, TXN8309DBrown Willard Ferrell · Fayetteville, GAN8311DCunningham James J · Midlothian, TXN8313DMclenaghan Alvin N · Phoenix, AZN8314DMclean Angus L · Bradenton, FLN8315DBurnd C R · Town Creek, ALN8318DHice Robert L · Panama City Beach, FLN8320DMiller Mark A · Hutchinson, MNN8322DTupelo Aeronautics Inc · Tupelo, MSN8323DRegistered aircraftN8324DLacour Erik · Clovis, CAN8326DSchulte Allison R · Trappe, MDN8327DLeavitt John C · Titusville, FLN8330DV-Tail Flyers Inc · Chanhassen, MNN8331DLee John M · Lakebay, WAN8333DRegistration Pending · Tibubon, CARegistration pendingN8334DDykes Robert W · Knoxville, TNN8342DTexas Logos LLC · Lometa, TXN8346DRegistered aircraftN8348DSanders Tyler A · Austin, TXN8349DSorenson Steve A · Cody, WYN8350DBas Part Sales LLC · Greeley, CON8351DDotson Eric E · Wagoner, OKN8357DQuinn Robert F · San Mateo, CAN8358DAskelson Eldon L · Meridian, IDN835BBusigin Tikhon · Ocala, FLN8360DSanders Dean L Trustee · Nordland, WAN8361DRiker Richard · East Falmouth, MAN8364DElliott Areospace LLC · Kalispell, MTN8366DPage Howard G · Burlingame, CAN8367DAg-Monkey Inc · Norris City, ILN8369DPalmer Paul H · Marshall, TXN8370DJones Richard P · Mukilteo, WAN8372DBuford Phillip N · Bethesda, DC
Back to Beech J35