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 ('0631410', '0630711')
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 ('0631410', '0630711')
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.
N6090LDarcor Inc · Hampstead, NCN6096LC&C Airlines LLC · Mesa, AZN6097LPetrovich Michael · Simpsonville, SCN6367LM&S Aero LLC · Wilmington, DEN6373LMcdermott Scott A · Boston, MAN6425LRegistration Pending · Hudsonville, MIRegistration pendingN6768FFallis Robert P · Keller, TXN6812TChambless Frank M · Cedar Bluff, ALN7200LWorley Matthew · Cordova, TNN72LMCoonan Paul M · Huntsville, MON7351LTaigen Robert L Jr · Queen Creek, AZN7371LMcewen Michael Trustee · Overgaard, AZN8005WBartkowiak John D · Moorhead, MNN813WKTinney Michael · Piedmont, ALN821KCIreland Robert D Jr · Gulf Breeze, FLN8764J374dk Aviation LLC · Sand Springs, OKN9059WGoodnow Connie R · Topeka, KSN915MTMcnutt William E · Ada, MIN9208LBrookway Investments LLC · Brookhaven, MSN920JLBaxley Aviation LLC · Baxley, GAN9498LRaber Jonathan L · Baltimore, MDN9500LAtlantic Aero Club Inc · Newark, DEN9505LClark Gabrial Scott · Humble, TXN9513LMott Terry W · Hampton, IAN951ANNorth Branch Aviation LLC · Fort Worth, TXN99YTWind Walker LLC · Tucson, AZN9JSAuburn Flight Time LLC · Auburn, AL
Back to American AA-5