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.
N62PMRoberts James A · Hamburg, ARN62YRSnyder George H Trustee · Lake Worth, FLN6320QLucas Warr & White LLC · Florence, SCN6326QMontpelier Gary L · Bushnell, FLN6327QHarrod Tracey Lynn · Bedford, KYN6329QRegistration Pending · Zavalla, TXRegistration pendingN6333QEgan Cherlye R · Ramona, CAN6334QJed-Aire Aviation LLC · Benson, MNN6335QChandler Elijah J S · Pilot Mountain, NCN639MARegistration Pending · Santa Cruz, CARegistration pendingN63MMNzere Michael · Crowley, TXN6400UAudetat Thomas Jr · Marana, AZN6401QHunter Donald J · Scottsdale, AZN6401UBlue Sky Aviation Adventures LLC · St George, UTN6402QMooney Mooney Mooney LLC · Gig Harbor, WAN6402UMccleave Thomas · Everett, WAN6403QMiller Fred J · Sahuarita, AZN6404UPhiyawa Airplane Holding Inc · Argyle, TXN6406QHilten Robert W · Columbus, MTN6408UMckee Michael S · Piney Creek, NCN6409QButz Kyle W · Swanton, OHN6409UJohnson Lynn · San Diego, CAN6410USturm Daniel A · Carroll, IAN6411UPaselk Daniel Guy · Fort Myers, FLN6414UHensley James R · Bertram, TXN6415UMccall Richard A · Lexington, NCN6416USt Marie Jack W · Encinitas, CAN6420ULambert Glen C · Las Vegas, NVN6421UAlpha 1 Aviation LLC · Helena, ALN6423USky West Aviation Inc Trustee · Albuquerque, NMN6425ULaird Kevin E · San Diego, CAN6426USmith Dustin J · Farwell, TXN6427UPrecision Pilot LLC · Weston, FLN6428UGrossman James W · Eureka, SDN642GDFitzpatrick Timothy Jr · Yerington, NVN6430UWallace Dale E · Edison, NJN6433URensberger Scott C · Lake Jackson, TXN6434UCapps James E · Lillington, NCN6435UStein Charles H · Belleville, ILN6442UUpchurch David A · Graton, CAN6443URaw Aero LLC · Warsaw, MON6445UFerrin Lora J · Rio Rancho, NMN6447UOlathe Spray Ser Inc · Olathe, CON6451UPatterson Scott K · Roswell, NMN6452UEllis & Ellis Aviation LLC · Haslet, TXN6459ULinck Market Inc · Little Rock, ARN6460UHayes Toby G · Idaho Falls, IDN6462UAnderton Roy · Colbert, OKN6464USherman Stanley Robert · Altus, OKN6468ULi Yoi Y · Largo, FL
Back to Mooney M20C