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 ('2071810')
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 ('2071810')
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.
N5925TGrizzle Kenneth A · Jerseyville, ILN5926TPalyash Neil J · Wichita, KSN5931TFreitas Durval S · Tulare, CAN5932TSmith Jason M · Holland, PAN5935TValley Wings Flight School LLC · Harlingen, TXN5938TShihadeh Luke C · Wasilla, AKN5939TAdkins Amanda J · Proctorville, OHN5943TMission Flight Academy · Redlands, CAN5944THills Jacob W · Lonepine, MTN5946TEasmunt David P · Hardin, KYN5947TStewart Edgar A · Glennallen, AKN5949TJoy Jeffrey · Pendergrass, GAN5952TWaters Brandon J · Bushnell, ILN5953THangar Ak LLC · Sterling, AKN5954TAeropro Aviation LLC · Brighton, MIN5956THout David D · Columbus, OHN5959TSchramm John · Walbridge, OHN5960TDonat Brandon L · Glendale, AZN5961THusky Transportation LLC · San Antonio, TXN5963TKnight Luke O · Monroe, IAN5964TColburn Shawn M · Monroe, GAN5965TJones Robert · Gulf Breeze, FLN5970TOmlid Robert L · Watford City, NDN5976TBickel Garret E · Perry, MON5977TBass Daniel J · Winona, MNN5981TLowe David · Sacramento, KYN5982TLifto Thomas W · Barronett, WIN5988TInvestopia Online LLC · Houston, TXN5989TKnudtson Bruce A · Sioux Falls, SDN5991TDelima Joseph D · Livermore, CAN5994TBundgard Peter A · Natchez, MSN5996TLopez Manuel G · Fort Washington, MDFirst renewal noticeN5997TFour Aces Montana LLC · Missoula, MTN6004TIrwin Donald L · Emporia, KSFirst renewal noticeN6008TYoungman Lawrence J · Penn Yan, NYN6009TGies Paul E · Wauwatosa, WIN6012TNgungi Andrew M · Haysville, KSN6014TRodriguez Richard · Indianapolis, INN6015TBellinger Joseph C · Waterloo, INN6016TStone Isaac L · Cushing, MNN6022THenderson Beverly A · Sharon Springs, KSN6029TMartling Brian W · Goddard, KSN6033TGordon Ralph C · Fredericksburg, VAN6035TCarson John C Jr · Enterprise, ALN6037TAndrew Franklin B · Intervale, NHN6045TSaladino Michael J · Metairie, LAN6046TDimaio Joseph V · Leesville, LAN6054TWestrum Enterprises LLC · Norwalk, IAN6055TCampbell Glen · Phoenix, AZN6057TFurlong Kelly · Athens, AL
Back to Cessna 150D