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 ('2071826')
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 ('2071826')
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.
N5299QJa Flight Services LLC · Sugar Grove, ILN52DRJbpm LLC · Otisfield, MEN5300QHopson Larry K · Conroe, TXN5303QWest Prairie Aircraft LLC · Weiner, ARN5307QSkyway Leasing Inc · Lakeland, FLN5308QBig Sky Leasing LLC · Boise, IDN5309QSauvageau Daniel W · Roseville, CAN5314QN5314q LLC · Titusville, FLN5315QLessig Bruce D · Casper, WYN5318QProsperous Holdings LLC · Gainesville, GAN5319QPurcell Melinda · Caseyville, ILN531CPRegistration Pending · Starkville, MSRegistration pendingN5323PCarls Phillip G · Frederick, MDN5325QIlm Aviation LLC · Waxahachie, TXN5327QLarsen Deziree L · Bay Point, CAN5330QBend Aircraft Mechanics LLC · Bend, ORN5338QFly By Knight LLC · Louisville, KYN5344QGraber Quinten R · Brooksville, MSN5345QRegistered aircraftN5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCN5353QRegistered aircraftN5359Q620 Stanley Aviation LLC · Meridian, IDN5361QBushre David N · Janesville, WIN5362QHelderman Curtis L · Newton, NCN5367QLeatherneck Aviation LLC · Billings, MTN5368QMobley Christopher M · Keysville, GAN5369QAirfleet Solutions LLC · Newark, DEN5373QMallatt Michael N · Galena, KSN5379QSky Limit Services LLC · Miami, FLN5380QFoy Timothy D · Malvern, PAN5381QAirgo Inc · Centralia, ILN5382QMiller Charles L · Mooresville, NCN5383QEight Three Quebec LLC · Arlington, VAN5390QIgnarro Jessie · Bay Shore, NYN5391QMja Aviation LLC · Channahon, ILN5392QLatitude Aviation LLC · Cedar Rapids, IAN5395QOwens John C · Mount Carmel, PAN5401QMaine Center For Classic Aviation · Pittsfield, MEN5403QAbriam Darryl · Dahlgren, VAN5407QR G V Flight Academy LLC · Bayview, TXN5409QOwens Anthony G · Kotzebue, AKN5412QWilson William W · Mccall, IDN5415QBrown James Jr · White Hall, ARN5416QSharp Jacob T · Frankfort, KYN5428QKruse Jakob · Parsippany, NJN5435QHutchins Kent F · Carbon, INN5436QAdler Richard A · Leland, NCN5437QMetro Technology Aviation Campus · Oklahoma City, OKN5444QChiavari Nicholas J · Havertown, PAN5449QHarper Randall W · Presque Isle, ME
Back to Cessna 150L