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.
N1407NLowe Martin · Culpeper, VAN1409NFuhrer Joshua · Massillon, OHN1412NRegistered aircraftN1414Frick Gary A Trustee · Marion, INN14140Hinson Steven L · China Grove, NCN1414NMulhern Ronald R · Santa Rosa, CAN1416NDenning Gregory F · Raleigh, NCN1419NTunnell Ga Jr · Dallas, TXRegistration revokedN141TEB-N-K2 LLC · Reserve, LAN1421NGoss Duane B · Providence Forge, VAN1423NStich Michael · Wamego, KSN1425NJolley William H · Wamsutter, WYN142BNJensen Harold G · San Antonio, TXN142PDTj Air Holdings Inc Trustee · Wilmington, DEN1432NSale Reported · Hooksett, NHSale reportedN1432VBlow Russell B · Virginia Beach, VAN1436NKersten Adrian Lee · Anchorage, AKN1438KKalember Duane D · Suttons Bay, MIN1438NMee Dennis M · Portsmouth, NHN1441NAir Tractor West Inc · San Joaquin, CAN1444WTurner Bob · San Diego, CAN1452NGrenie Arles A · Richland Center, WIN1453NLester James A · Brooksville, FLN1455NRegistration Pending · Snellville, GARegistration pendingN1458NTweety Co LLC · Toledo, OHN1459NTilbury Mitchell A · Blaine, MNN145RLPerrycook Flight Services LLC · Gig Harbor, WAN1463NPenney John C Trustee · Evergreen, CON1464NMartin Eugene T · Sioux City, IAN1466NGrimmett Carl W · Gravois Mills, MON1469NCox Natalie · Beach City, TXN146TMLong James · Santa Rosa, CAN1472NPruzek Russell T · New Auburn, WIN1474NTanzer Matthew M · Durham, NCN1475NCochran Robert · Marathon, NYN148SPVan Wagner Aerial Media LLC · Hollywood, FLN1494NGarvin Douglas A · Waterford, PAN1499NSylvester Sean · North Pole, AKN1500NOrlandi Properties LLC · Blairstown, NJN1501NWatson David P · Denison, TXN1502NRyan Montambo · Mooresville, NCN1505NSmith Colby B · Higden, ARN1506NRegistration Pending · Westfield, INRegistration pendingN1511NMurphy John C · Huntingdon, TNN151APChisum Kenneth J · Valley View, TXN1525N88 Charlies Inc · Mukwonago, WIN1534NMaddex William E · Battle Ground, WAN1542NVintage Aero Collection Inc · Wilmington, DEN1546NGoolsby Richard A · Mulberry, FLN1548NHorwitz Kenneth D · Bremerton, WA
Back to Piper J3C-65