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 ('2071816')
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 ('2071816')
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.
N8461JBailey Roger · Mccool, NEN8472JEck Alan C · Henderson, MDN8473JKnighton Dennis · Headland, ALN8474JHoward Linda Faye · Pink Hill, NCN8475JRemar Chuck · Poplar Grove, ILN8477JLake Benjamin Joseph · Garland, TXN8478JKnapp Caleb J · Aledo, TXN8480JLeach Flight Services LLC · Aledo, TXN8483JHouston County Flying Club · Crockett, TXN8484JBivens Jason D · Duncan, OKN8486JLysogorski Edward P · Bridgeport, MIN8487JSeigler William C · Weatherford, TXN8490JB&K Holdings LLC · Birmingham, ALN8495JParks Ryan Alan · Newcastle, WYN8500JRiley Alfred E III · Norristown, PAN8505JKunz Isaac A · Texarkana, TXN8506JHorning Richard H · Galion, OHN8508JJanssen Willis W · Ault, CON8513JHurd Billy R · North Pole, AKN8522JValley Jacob A · Brewer, MEN8525JBicknell Hilary E · Warwick, RIN8529JBrucks Mark D · Peachtree City, GAN8531JCelestial Kinetics Flight Academy LLC · Waupaca, WIN8532JWerner Felix A · Picayune, MSN8540JSale Reported · Lamar, COSale reportedN8542JMcdowell Donald L · Geneva, OHN8547JL&R Consulting LLC · Las Vegas, NVN854AJLowe David · Sacramento, KYN8553JMindy Limited LLC · Muscatine, IAN8555JBauer Walter G · Neenah, WIN8557JRobertson Billy J Trustee · Cleveland, OKN855TWMapes Peter B · Oscoda, MIN8563JTschepen Leo R · Bisbee, NDN8570JBitikofer Brent · Kansas City, KSN8571JRoam Gary A · Venice, FLN8574JHubenthal William L · Carbondale, ILN8578JParagon Aviation LLC · Reading, PAN8582JMarchione Laverne R · Diamondville, WYN8584JDarrach Todd I · Rhome, TXN8587JMorgan Jeffrey E · Peebles, OHN8588JLyons Donald F · Cheverly, MDFirst renewal noticeN8596JNelson David D · Mercer, PAN85SSCornelius John W · Elgin, TXN8604JPouncey Wayne · Merced, CAFirst renewal noticeN8606JMaedgen Gary W · Voss, TXN8608JWalker Rhan E · Pleasant Hill, MON8610ZJayviation Inc · Lake City, FLN8614JMoles Dale A · Mooresburg, TNN8619JErickson Max W · Cumberland, WIFirst renewal noticeN8620JCampbell John L · Lincoln, NE
Back to Cessna 150G