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 ('5870208')
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 ('5870208')
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.
N7161UJones Barkley · Moultrie, GAN7162UEcklund Scott Trustee · Brandon, SDN7163UPatterson John M II · Frankfort, KYN7164UKnapp Schuyler S K · Upperville, VAN7170UWorley Ronald W · West Jefferson, NCN7170VKrack John L Trustee · Fridley, MNN71728Guskea Andrew E · Jericho, VTN7172UMark21-Charlie LLC · Brownsburg, INN7172VGanji Borna · West Windsor, NJN7174UVondross James B · Portland, ORN7174VEast Carolina Aviation LLC · Camden, NCN7175UWagner Mark · Grass Valley, CAN7178UBell Construction Inc · Napa, CAN7179UBarbee James E · Mason Neck, VAN717BYWhite Kenneth · Rancho Cordova, CAN7180UTatum Brett A · Jones Creek, TXN7181URegistration Pending · North Conway, NHRegistration pendingN7182UFrasco Leonard · Cocoa Beach, FLN7195VScherer Eric · Mooresville, NCN71CRSoto Arturo J · Laredo, TXN721LPN721lp LLC · Gainesville, GAN722CSBoccaccio Peter Anthony · Burke, SDN724JMTygielski Brent R · Clarkston, MIN727PANorat Richard N V · Kerrville, TXN72FYStrongpoint Real Estate Group LLC · Danville, PAN72JCBores Scott J · Huron, OHN730ETWolfgram Patrick Michael · Ham Lake, MNN73DXAj Airlift LLC · Arlington, MAN73SDMedlock-Turek Patick Evan · Clifton, NJN7415VHall Kevin · Morgan, UTN7417VCottage Village Living II LLC · Brownfield, TXN7418VGilinger Lisa C · Santa Barbara, CAN7421VYacuzzi Gerald A · Quinque, VAN7422VPanto Anthony · Jackson, NJN74553Young John H · Sheridan, WYN74555Pieszala John W · Larksville, PAN74556Gutierrez Juan · Sarasota, FLN7463VHarper Abe L Jr · Daphne, ALN7464VSpaeth Roger P · Roseville, CAN7466VBaker Ronald James · Queenstown, MDN7471MN7471m LLC · Sheridan, WYN753JBCraig Connor J · Mesa, AZN757BBarber Shoppe Inc DBA · Cameron Park, CAN7700MWood Duck Loop LLC · Mooresville, NCN7701MHurt Roy DBA · Newark, OHN7702MCullen William Edward · Mill Valley, CAN7704MCollins Benjamin N · Chapel Hill, NCN770DKStanton Michael · Wilmington, NCN7712JChapman James A · San Antonio, TXN771JNSteiner Martin A · Bellaire, OH
Back to Mooney M20C