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.
N21504Lunsford Jonathan Lynn · Hurst, TXN21505Bagnall Benjamin D · Portsmouth, OHN21506Rootlieb Jerry V · Seal Beach, CAN21519Butler Richard A · Gatesville, TXN2151MOlstad Christopher A · El Cajon, CAN2152MAllen Michael R · Graham, NCN21560Anderson Cynthia L Trustee · Hermantown, MNN2156MMassey Sam A · Wills Point, TXN21575Registration Pending · Parsons, KSRegistration pendingN21577Lihs Aaron J · Sioux City, IAN21584Alexander Victor P · Scooba, MSN21595Brandt Terry R · Hood River, ORN21609Talton David B · Wendell, NCN21610Rhodes Mark A · Belle Chasse, LAN21631Sitaras Evangelos · Ladonia, TXN21638Slayback Eric J · Richland Center, WIFirst renewal noticeN21647Eddy William C · Sugar Hill, GAN21658Stewarts Aircraft Service Inc · Waynesville, OHN21667Camas-Washougal Flying Club · Camas, WAN21668Sibra Ray W · Big Sandy, MTN2166YSkyeair LLC · Palm Beach, FLN21675Harman Bradley I · Nacogdoches, TXN21677Forsyth Myron G · Cupertino, CAN21681Adkisson Wanda M · Hammond, ILFirst renewal noticeN21687Boyd Darrell M · Claremore, OKN2168MJohnson Terri L · Spring Green, WIN2173MFussell Leon J · Broxton, GAN2175MSpangenberg Daniel M · Greenville, MIN2178MHillman Edward Jr · Alliance, OHN217DRTec Concepts LLC · Fruita, CON2180MMorris Julie L · Mabank, TXN2181MGilbert Aviation Inc · Wilmington, DEN21820Lemons Mike · Conway, ARN21821Johnston Thomas D · Austin, TXN2182MMoonrise Soaring Inc · Wilmington, DEN21834Petri James P · North Adams, MAN21848Legros Donald P · Jennings, LAN21851Parker Andrea M · Camas, WAN21864Skipper Arthur F · Sandy, ORN21881Stewart Bryan P · Carson City, NVN2188YGroat Stanley G · Austin, ARN2191MHodges Michael D · Tulsa, OKN2192MVan Wagner Aerial Media LLC · Hollywood, FLN2197MBaker Phillip L · Alpine, TXN2198MSale Reported · La Porte, INSale reportedN2199YRegistration Pending · Pontiac, ILRegistration pendingN21KNWade Ashley B · Eloy, AZN2206MSyme John Robert · Seville, OHN2207MHalunen A John · Naples, NYN2208MSeivers Matthew R · Medina, OH
Back to Piper J3C-65