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 ('2071802')
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 ('2071802')
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.
N7762EPierce Roger V · Broken Arrow, OKN7765EFuellner Sean L · Shelocta, PAN7766EArmitage Alexandra S · Nederland, CON7767EBruce Matthew · Arlington, TXN7768EYounger David B · Port Angeles, WAN7769EFieldgrove Matt · Somerton, AZN7770EDye John Donald Jr · Higginsville, MON7771EEchanove Michael · Palouse, WAN7776EOtte Bowdie · Norfolk, NEN777PTGrandair Aviation Inc · Grand Ledge, MIN7780EBush Consulting Services LLC · Pensacola, FLN7783EMobile Aviation Solutions LLC · Sharpsburg, GAN7790EScheall Daniel C Sr Trustee · Newport, ORN7794EMagnuson Steven M · Modesto, CAN7797ERegistration Pending · Kingsford, MIRegistration pendingN7798EPnwav8r LLC · Seattle, WAN7800EWings Unlimited Inc · Loup City, NEN7801ENorman Dennis E · Bothell, WAN7807ERegistered aircraftAssigned, pending cancellationN7808ESauls Billy J · Hollow Rock, TNN7809EHavelka Justin R · Mcgregor, TXN7811EWinkler William R III · Boone, NCN7818EHurlin Nicholas E · Newburyport, MAN7819ELinscott Jeffrey R · Boring, ORN7821EOrvin Sanden Inc · Wyndmere, NDN7827EFellars Richard L · Phoenix, AZN7829EHochstatter Pat J · Moses Lake, WAFirst renewal noticeN7833EChecky Allan O Jr · Merrimac, WIN7835EUnternaehrer Robert U Trustee · Brunswick, MON7842EErkert Matthew P · Lebanon, PAN7845EWallace Terry E · Bedford, TXN7849EDelaney Jerard Emmet II · Monroe, MIN7853EFelton Marion L · Dickens, IARevoked, canceledN7857ELout James Mike · Jasper, TXN7858EWhite Larry K · Pittsburgh, PAN7860EBoomer Aviation Inc · Fort Walton Beach, FLN7861EDoyle Vic L · Two Buttes, CON7866EStramel Brian K · Beaverton, ORN7867ELemieux Matthew T · Ettrick, WIN7870EConner Walter L · Los Lunas, NMN7871EValentine Barry L · Brunswick, MEN7880EBootz Terry A · Canyon Lake, TXN7883EMcentire Ronald · Adams, ORN7884ERabenberg Travis T · Lowell, MIN7890EShogren Marina L · Fort Pierce, FLFirst renewal noticeN7892EFox Stephen A · Wasilla, AKN7894EMou Air Group LLC · Kalispell, MTN7901ETomlin Rollin D · Wilmington, OHN7906EMcglynn Brian J · Independence, ORN7909ENeiggemann Patrick B · Ventura, CA
Back to Cessna 150