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 ('9230108')
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 ('9230108')
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.
N2446BHolliday Mark E · Lake Elmo, MNN2449BHolliday Mark E · Lake Elmo, MNN2451BSimply Living LLC · Fort Myers, FLFirst renewal noticeN2455BGillaspie Wade · Huntsville, TXN2457BGurel Samuel E · Bentonville, ARN2460BSwift Museum Foundation Inc · Athens, TNN251DTSwift Action LLC · Akron, OHN3264KBudde Bobby M Jr · San Jose, CAN337ECrosswhite Dan F · Axtell, TXN3767KSkibinski Jan Joseph · Midlothian, VAN3785KBartholomew Don · Gardnerville, NVN3793KVolpe Francis B · Boynton Beach, FLN3812KCook Steven A · Vineland, NJN3817KMax Cl Inc · Wilmington, DEN3820KRutter Clarence W III · Norman, OKN3823KHarris Kenneth L · Greeley, CON3824KJones James Milton · Madison, GAN3830KBrian Engineering & Consulting Pllc · Tulsa, OKN3833KSampson Joel L · Belview, MNN3841KCaito Michael F · Boynton Beach, FLN3842KBrunelle Alexander · Schaumburg, ILN3846KPrivitt Bret J · Forest Hill, TXN3849KSmith Jeffrey C · Asheboro, NCN3856KSimply Living LLC · Fort Myers, FLN3860KWind And Wheels LLC · Itasca, ILN3863KMclean Robert M Jr · Darlington, MDN3864KAndersen Allen E · Sandy Valley, NVN3866KAircraft Partner Holdings Inc Trustee · BerlinN3870KUlmer Bryce D · Locust Grove, GAN3871KDesert Wind Wings LLC · Mesa, AZN3875KLemke Brian · Joliet, ILN3876KWilson Stephen A · Granbury, TXN3880KRhodes Tracy · Reno, NVN3885KFlies Warren E · Mesa, AZN3889KBohl Howard M · Temecula, CAN3899KRogers Robert L · Corrales, NMN44SSEllingham Jeffrey B · Elko, GAN46VPVan Pelt Martin J · Venice, FLFirst renewal noticeN6074VBabb Bradley E · Enid, OKN711EFoushee Michael J · Columbus, INN767DKAbbott Donald K · Gallatin, TNN77753Wilson Stephen A · Granbury, TXN77755Plane Fun Inc Tr Trustee · Snellville, GAN77756Sinclair James Stanley · Douglas, GAN77759Walsh Samuel R · Bemidji, MNN77760Schooler Gary M · Mesa, AZN78056Plane Fun Inc Tr Trustee · Snellville, GAN78161Qualitair LLC Trustee · MichelstadtN78168Green Miles Wilder · Elm Grove, WIN78247Schmillen Gregg A · Phoenix, AZ
Back to Temco GC-1B