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 ('1152704')
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 ('1152704')
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.
N52TADowell Thomas · New Smyrna Beach, FLN550JAAlves Gerald T · Alamo, CAN550LEFlycarolina LLC · Concord, NCN550RNovember Sierra Aviation LLC · Oneill, NEN5779KHarris Aircraft Leasing Co · Oklahoma City, OKN6212VHoffman Eric M · Kerman, CAN632CMRestoration Wings · Lago Vista, TXN651TBrabant Charles A · Westminster, CON69YMCaraway Michael · Saint Anne, ILN70MFMoyer Aviation Inc · Tobyhanna, PAN717TMulti Engine Flight Time LLC · St George, UTN7501SPressley Aviation LLC · New London, NCN779MMMartin James D · Graford, TXN78DDKutzner Richard W · Bakersfield, CAN791JBFrylock LLC · Hurricane, UTN841LAvery Adam · Edmonton, KYN8511MJ & J Aviation Services LLC · Simpsonville, SCN8577MSkyfix International Inc · Fort Lauderdale, FLN8630MMerrills Inc · Shreveport, LAN877FBOverlander Aviation LLC · Palo Alto, CAN919YFlow Pro Products Inc · Romeoville, ILN922QDragonlady Barron LLC · Gardnerville, NVN927PRMichael Magic Carpet LLC · Stuart, FLN931RDMorgan Gabriel A Sr · Newport News, VAN9516YRanz Mark K · Seattle, WAN9540YRobert Enrique Guerrero De Jesus · Sparta, NJN9549YBiederman Clifton E · Jasper, FLN9582YCastlewood Medical LLC · Dallas, TXN9598YOber John A · Candor, NYN9606YWeber David J · Waller, TXN9618YBrant Owen D · Delta Junction, AKN9669YFlorida Aero Group Inc · Wilmington, DEN9683LBorn Mark · Rockwall, TXN9733YSs & C Aviation LLC · North Fort Myers, FLN9749YMckenney Brett K · Billings, MTN9779YNovosielski John · Richfield, OHN9783YOneal Hollis · Deridder, LAN97BWDillard Wendell H · Centerville, TXN984QSpring Lake Aviators LLC · Quincy, ILN99BGTfs Air LLC · Loveland, CO
Back to Beech 95-A55