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 ('7100510')
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 ('7100510')
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.
N1557NHenderson James R · Garden Prairie, ILN1559NJohnston Samuel P · Spring Grove, ILN155DDGilman Trevor J DBA · North Adams, MAN1560NDavis Steven · Texarkana, TXN1564NWeller Zachary S · Salado, ARN1565NMastodon Aero LLC · American Fork, UTN1568NKing Stephen W · Kerrville, TXN1573NPorter Bonnie A · Brentwood, NHN1576NSmith Bradford B · Marietta, OHN1577NMichael Cheryl K · Medford, OKN1585NTcf Ventures LLC · Wilmington, DEN1586NMighty Float Cub LLC · Grand Isle, VTN158JWRegistration Pending · Big Lake, MNRegistration pendingN1591NCoffman Robert P · Bigfork, MTN1592NDerwin Lawrence R · Santa Paula, CAN1594NMoore Frederic · Manning, SCN1597NSilver Ranch Airpark Inc · Jaffrey, NHN1598NHill Evan M · Wasilla, AKN1612HKutilek Emil J · Charlottesville, VAN16EHOlivier Seth · Baskin, LAN1716MMinor James F · Lake Dallas, TXN17171Kutilek Emil J · Charlottesville, VAN175BOffner William A · Amery, WIN175KMoore Charles E · Gibsonville, NCN1776Polyspray Corp · Asheboro, NCN17777Yolo Farms LLC · Raleigh, MSN17NHPalmer Ronald E Trustee · Hopkinton, NHN18161Wood Ellis G · Statesboro, GAN1829BWatson Michael D · Hogansville, GAN1863MBuckelew James Eric · Gulf Breeze, FLN18999Cub Air LLC · Barrington, ILN190DLLeedom David A · Escondido, CAN1938CHerrold Dustin R · Seward, NEN1940BBraatz Ronald W · Bend, ORN1941WDonatelle Charles S · Edina, MNN1946Takakhi Steve B · Intl Falls, MNN1946JCordray Dave E · Garden Prairie, ILN1946LHinchey Ken M · Anchorage, AKN1971MLee James R · Hamilton, TXN1973MScruggs John S · Hazlehurst, GAN1979MWilliams C M · Kennesaw, GAN198AFletcher Flying Service 419 LLC · Labelle, FLN198KTurner Lee H Trustee · Felton, DEN19ANGiles Richard · Portland, ORN2002MFoster Dean C · Sagaponack, NYN2010MThomas Spencer S · New Castle, CON2012MSmith Bethany S · Athens, ALN20149Dendy Dwight E · Caledonia, ILN2016MHenkelmann David H · Janesville, WIN2019MCedar Creek Flying Club Inc · Decatur, IN
Back to Piper J3C-65