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.
N8317JHinojosa Edward · Georgetown, TXN8318JGreat Lakes Air Ventures LLC · Mason, MIN8322JMiller Patrick · Riverside, CAN8323JKc Eagles Soaring Club · Gardner, KSN8327JSaunders Grant J · Sebring, FLN8328JTreat James · Batesville, ARN8329JWooley Eva · Hephzibah, GAN8336JGoat Rodeo Aviation LLC · Leesburg, INN8337JGeorge Downer Flyers LLC · Aliceville, ALN8346JHodgman Robert J · Yakima, WAN8350JSustarich Stephen M · Ketchikan, AKN8351JRkd Aviation Services Inc · Dallas, TXN8352JByrds Wholesale Inc · Clayton, NCN8355JPadilla Hector F · Mountain View, CAN8358JMorrow John E · Clarendon, TXN8359JManchester Eric S · Milton, VTN8361JCoughlin Kevin P · Ridge, NYN8366JRobertson R Topp · Decatur, TXN8368JVickers Lindsay · Fuquay Varina, NCN8369JDtm Enterprises Inc · Bronson, MIN8370JBrown David A · Lumberton, TXN8372JPaquette Michael J · Greene, NYN8375JAtlanta Aircraft Consultants LLC · Rex, GAN8379JLin Air LLC · Oviedo, FLN8382JHouseknecht Thomas · State College, PAN8384JKondol Andrlej J · Maspeth, NYN8385JJones Stanley E · Vallejo, CAN8386JMyers Raymond R · Deer Park, WAN8388JCunningham Kevin M · Alexandria, MNN8391JDaily Joshua J · Rochester, WAN8397JRegistered aircraftN8400JBlue Wings LLC · Brecksville, OHN8401JKingdom Air Corps · Sutton, AKN8404JMalphurs Larry Neil · Pooler, GAN8410J1st Flight LLC · Allentown, PAN8412JMckeon Michael F · Warren, MEN8413JGrimaldos Juan P · Fairbanks, AKN8414JRegistered aircraftN8427JLee Susan Administrator · San Antonio, TXN8429JRegistration Pending · Cincinnati, OHRegistration pendingN8430JBuchinsky Steven · West Plains, MON8438JBlackwood Larry W · Elm Mott, TXN8441JAviation Trust Co LLC Trustee · Oklahoma City, OKN8443JThunderbolt Resourcing LLC · Warrensburg, MON8446JBent James L Jr DBA · Palatine Bridge, NYN8449JSchaff James F · Gakona, AKN8455JBentz Jack E · Huntington, WVN8456JHam Russell W · Dike, TXN8458JGp Aviation Leasing LLC · Hughson, CAN8460JHouston Juan D · Parkton, NC
Back to Cessna 150G