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 ('2072724')
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 ('2072724')
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.
N2500RN2500r LLC · Florence, SCN2501QEcological Flight Services LLC · Stuart, FLN2502RLovell John W · Sherborn, MAN2503RNicoliei Paul · Ione, CAN2504RJht Aviation LLC · Longview, TXN2506QJohnson Jason D · Doniphan, MON2507RKandle Sherry A · Boise, IDN2508RBrodt Gregory L · Chetek, WIN2511RDickey Mark D · Pendleton, ORN2512QPeacock Jeffery D · Cleburne, TXN2514RRichmond Patrick A · Glenmora, LAN2518QSwaldi Thomas · Marion Heights, PAN2519RPentzien Inc · Omaha, NEN2520QRcmt Properties LLC · Havre, MTN2520RWinston Douglas S · Star, IDN2522QJohnson Sales & Service Inc · Ong, NEN2522RPechanec Brent L · Wichita, KSN2523QLusk T Quizy · Springfield, CON2523RBergamaschi Brian A Trustee · Davis, CAN2524QBellamy Flying LLC · Elwood, NEN2525QHohman Cory A · Lometa, TXN2525RBrandt Jimmie L · Elbert, CON2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKN2527QTwenty Inc · Wilmington, DEN2528RHutchens Robert L II · Mocksville, NCN2530RHines David L · Lancaster, CAN2532RDelong Erika Dee · Forest Lake, MNN2533QBusse Alana · Thousand Oaks, CAN2533RAdams Michael B · Scottsdale, AZN2534RRobuck Dale J · Knoxville, IAN2535QDerodeff Stephan A · Nipomo, CAN2536QWiebe Tim · Newton, KSN2538R1 Point 21 Gigawatts LLC · Auburn, WAN2539RWillard John E Jr · Rockwood, MEN2540RFreeman Josh · Turtle Lake, NDN2542RThordarson Gudsteinn T · La Porte, INN2543RSaddlery Air Inc · Des Moines, IAN2544RBill Church Real Estate LLC · Midland, MIN2545RYad Aviation LLC · Cherry Hill, NJN2546RStephani Timothy Michael · White Lake, WIN2548RHuertas Andrew · Van Nuys, CAN2550RSmalldridge Jonathan D · Arcadia, CAN2551RHendrix Casey W · Ennis, TXN2552RHooper Jerald Ray · Parker, AZN2553QSanders William R Jr · Lafayette, CON2553RDepore Joseph E · Charleston, SCN2554RBartlett Richard H · Sussex, NJN2557RWhite Willis W · Boise, IDN2558RKahn Steven P · Boise, IDN2559QJordan Valley Aviation LLC · Jordan Valley, OR
Back to Cessna 182K