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 ('2074242')
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 ('2074242')
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.
N69699Three-Ten LLC · Lewes, DEN69704Donahue Paul · West Palm Beach, FLN69708South Seattle College · Seattle, WAN69723O'Brien John P · Centerville, OHN69728Sharff Steven T · Georgetown, DEN69729Eastern Florida State College · Cocoa, FLN69743Howard Richard J · Sioux Falls, SDN69744Registered aircraftN69754Elevated 7 LLC · Kalispell, MTN69797N69797 LLC · Denver, CON69831Epic Aviation Services LLC · Kemah, TXN69842D2 Aviation LLC · League City, TXN69846Billingsley Arthur B · Green Cove Springs, FLN69848Onaero Inc · Santa Monica, CAN69937Hellix LLC · Charlotte, NCN69938Stapleton John Blase · Gulf Shores, ALN69942Columbus State Community College · Columbus, OHN69951Cosper Jared L · Austin, TXN699WSGivens Byron Keith Jr · Warner Robins, GAN69HBRowe Michael J · Crest Hill, ILN711CTClinton 83 Aviation LLC · La Place, LAN711MM711mm LLC · Boerne, TXN713MFBoundless Aviation LLC · Wilmington, DEN718MAGlinn Andrew T · Keystone, NEN71WDBlach Rhino Ltd LLC · Phoenix, AZN721SJAir America Flight Center LLC · Daytona Beach, FLN7505QJohnson Michael L · Jefferson, TXN7510QOne Zero Q LLC · Mount Pleasant, MIN7512QGorge Winds Aviation Inc · Fairview, ORN7517QQuay Ventures LLC · Alto, TXN7525QBuckin Donald L · Phoenix, AZN7526QWhat A Day To Travel LLC · Edgerton, WIN7531QSantiago Jose G Jr · Woodstock, GAN7537QRegistration Pending · Defiance, OHRegistration pending, pending cancellationN7552QTaylor Randy L · Upland, CAN7554QSky Farmer LLC · Culleoka, TNN7564QFairchild Chad E · Logandale, NVN7568QJughead Aircraft LLC · Salina, KSN7586QTyler Rdh Investments LLC · Tyler, TXN7589QTemptation Motors Ltd · Hayward, CAN758DCSale Reported · Altoona, FLSale reportedN7600QTwin D LLC · Lake City, FLN7602QKbg Air LLC · Deerfield Beach, FLN7626QSnap Roll Enterprises LLC · West Chester, OHN7638QGunder Austin C · Red Lion, PAN7644QSmith Carl D · Durham, NYN7651QAmerican Academy Holdings Inc · Stanford, CAN7652QBoone Aviation LLC · Valdosta, GAN7658QRamos Mario · Anaheim, CAN7661QCooper Kenneth E · Whiting, IN
Back to Cessna 310Q