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 ('8050153')
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 ('8050153')
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.
N136YPFault Line Flyers · Leander, TXN236WEMarks Peter J · Long Branch, NJN36148Sky Sailing Inc · Warner Springs, CAN3614NIngs Deborah · Centennial, CON36156Moos Milton H Trustee · Westerville, OHN3615BDifco Leasing LLC · Newark, DEN36166Grecco Joseph J · Saddle Brook, NJN3616FWengair LLC · Powell, WYN3616GArizona Soaring Inc · Maricopa, AZN3617BCentral Pennsylvania Soaring Association Inc · Lemont, PAN3617DShortridge Randall A · Mesa, AZN3617ETampa Bay Soaring Society Inc · Zephyrhills, FLN3617QCermack Michael W · Quartz Hill, CAN36183Kendallville Soaring Club Inc · Kendallville, INN3618DAndrew Ross F · Woods Cross, UTN3619BLeggett David R · Bangor, PAN3619GSchrepple Edward W · Shamong, NJN3619PKraemer Richard A · Hollywood, FLN3619UWinsor Wyant W · Tehachapi, CAN36204K & L Soaring LLC · Cayuta, NYN3620TNevada Soaring Association Inc · Reno, NVN3621BTampa Bay Soaring Society Inc · Zephyrhills, FLN3621GSimpkins Haskell · Cincinnati, OHN3621TButler Thomas K · Austin, TXN3622BHoran W Gareth · Glenside, PAN3622WSuperior Soaring LLC · Scottsdale, AZN625CWTrottier Walter R · Bronx, NYN96CGGlasford John T · Rapid City, SD
Back to Schweizer SGS 1-36