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 ('1151406')
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 ('1151406')
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.
N8819MSorem James R Jr · Tulsa, OKN8822MCullum Daniel · Liberal, KSN8823MBurcham Jeffery S · Mooresville, NCN882ECN7535z LLC · Smithfield, NCN8833MMike & Starla Mcevers Properties LLC · Dalhart, TXN8839MTedrow Myron A · Rutledge, TNN8843MBuckel Enterprises LLC · Ellison Bay, WIN886MEHbss LLC · Jefferson Hills, PAN8911MCarson Daniel E · Grove City, OHN8913MDan Jay Aircraft Sales Inc · Chico, CAN8914MShively Kevin Rowe · Wray, CON8916MJohnston Garrett · Flint, TXN8918MQualitair LLC Owner Trustee · MichelstadtN8926MFreeman Darrell E · Piperton, TNN8927MLathrop James C · Ardmore, TNN8931MCaudle James R · Catawba, NCN8936MCasper Holdings Inc · New Castle, DEN8937MJohn L Schulz · Sayville, NYN8941MFord Kevin A · League City, TXN8945MAaa Aviation LLC · Donalsonville, GAN8952MSpellmeyer John · Derby, KSN8955MPasqualino Mark W · Ocala, FLN8956MBender Parker J · Independence, MON8957MExport Eagle Aviation Corp · Coral Springs, FLN8963MSpicer William Harold III · Eads, TNN8964MPlucinski David J · San Clemente, CAN8967MSanocki Equities · Hawthorne, CAN8968MC Hanna 29dd LLC · Little Rock, ARN8973MMacivor Keith A · Houston, TXN8977MSmooth Sky LLC · Moses Lake, WAN8980MStanley Leroy III · Little River, SCN8FCGrefsrud James L · Morristown, AZN905QSky Pilot Aviation Inc · Carlsbad, CAN90DCHawk Xp Aviation LLC · Mooresville, NCN90GWSky West Aviation Inc Trustee · Albuquerque, NMN922JRBrown Christopher John · Virginia Beach, VAN930QWilhelmsen George R · Rochelle, ILN931QJohn E Bowen · Ocala, FLN932QPicotte Paul C · Fallon, NVN934QEmery Edward F · Orangeville, PAN936QEdinger David G · East Stroudsburg, PAN937QHumbert Jeffery Michael · Cottonwood, CAN940QHoward Garth J · Sacramento, CAN941QSiesta Aviation Group LLC · Springboro, OHN947QPeed Robert M · Madras, ORN950QDodson International Parts Inc · Rantoul, KSN9511YSelvidge John K Trustee · Edgewood, NMN9522YMissouri Aviation Inc · Leeton, MON9534YHulsair LLC · Jasper, INN953QRincon Marco T · Houston, TX
Back to Beech 35-B33